transelate this scripts

[romell]

SELECT HIER.Initial_State,HIER.Depth, HR_GENERAL.DECODE_ORGANIZATION(HIER.organization_i d_child) LABEL,''Icon,

HR_GENERAL.DECODE_ORGANIZATION(HIER.organization_i d_child) Data

FROM (SELECT 1 Initial_State, level Depth,POSE.ORGANIZATION_ID_CHILD

FROM per_org_structure_elements POSE

WHERE POSE.ORG_STRUCTURE_VERSION_ID = (SELECT POSV.ORG_STRUCTURE_VERSION_ID

FROM PER_ORG_STRUCTURE_VERSIONS POSV, PER_ORGANIZATION_STRUCTURES POS

WHERE

POS.NAME = 'NCB Hierarchy'

AND POSV.BUSINESS_GROUP_ID = TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID '))

AND posv.ORGANIZATION_STRUCTURE_ID = pos.ORGANIZATION_STRUCTURE_ID

AND POSV.DATE_FROM = (SELECT MAX(POSV1.DATE_FROM)

FROM PER_ORG_STRUCTURE_VERSIONS POSV1

WHERE POSV1.ORGANIZATION_STRUCTURE_ID = POSV.ORGANIZATION_STRUCTURE_ID))

START WITH POSE.ORGANIZATION_ID_PARENT = (TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_I D')))

CONNECT BY PRIOR POSE.ORGANIZATION_ID_CHILD = POSE.ORGANIZATION_ID_PARENT) HIER







SELECT 1 Initial_State, level Depth,POSE.ORGANIZATION_ID_CHILD

FROM per_org_structure_elements POSE

WHERE POSE.ORG_STRUCTURE_VERSION_ID = (SELECT POSV.ORG_STRUCTURE_VERSION_ID

FROM PER_ORG_STRUCTURE_VERSIONS POSV, PER_ORGANIZATION_STRUCTURES POS

WHERE

POS.NAME = 'NCB Hierarchy'

AND POSV.BUSINESS_GROUP_ID = TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID '))

AND posv.ORGANIZATION_STRUCTURE_ID = pos.ORGANIZATION_STRUCTURE_ID

AND POSV.DATE_FROM = (SELECT MAX(POSV1.DATE_FROM)

FROM PER_ORG_STRUCTURE_VERSIONS POSV1

WHERE POSV1.ORGANIZATION_STRUCTURE_ID = POSV.ORGANIZATION_STRUCTURE_ID))

START WITH POSE.ORGANIZATION_ID_PARENT = (TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_I D')))

CONNECT BY PRIOR POSE.ORGANIZATION_ID_CHILD = POSE.ORGANIZATION_ID_PARENT

[romell]

SELECT HIER.Initial_State,HIER.Depth, HR_GENERAL.DECODE_ORGANIZATION(HIER.organization_i d_child) LABEL,''Icon,

HR_GENERAL.DECODE_ORGANIZATION(HIER.organization_i d_child) Data

FROM (SELECT 1 Initial_State, level Depth,POSE.ORGANIZATION_ID_CHILD

FROM per_org_structure_elements POSE

WHERE POSE.ORG_STRUCTURE_VERSION_ID = (SELECT POSV.ORG_STRUCTURE_VERSION_ID

FROM PER_ORG_STRUCTURE_VERSIONS POSV, PER_ORGANIZATION_STRUCTURES POS

WHERE

POS.NAME = 'NCB Hierarchy'

AND POSV.BUSINESS_GROUP_ID = TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID '))

AND posv.ORGANIZATION_STRUCTURE_ID = pos.ORGANIZATION_STRUCTURE_ID

AND POSV.DATE_FROM = (SELECT MAX(POSV1.DATE_FROM)

FROM PER_ORG_STRUCTURE_VERSIONS POSV1

WHERE POSV1.ORGANIZATION_STRUCTURE_ID = POSV.ORGANIZATION_STRUCTURE_ID))

START WITH POSE.ORGANIZATION_ID_PARENT = (TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_I D')))

CONNECT BY PRIOR POSE.ORGANIZATION_ID_CHILD = POSE.ORGANIZATION_ID_PARENT) HIER







SELECT 1 Initial_State, level Depth,POSE.ORGANIZATION_ID_CHILD

FROM per_org_structure_elements POSE

WHERE POSE.ORG_STRUCTURE_VERSION_ID = (SELECT POSV.ORG_STRUCTURE_VERSION_ID

FROM PER_ORG_STRUCTURE_VERSIONS POSV, PER_ORGANIZATION_STRUCTURES POS

WHERE

POS.NAME = 'NCB Hierarchy'

AND POSV.BUSINESS_GROUP_ID = TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID '))

AND posv.ORGANIZATION_STRUCTURE_ID = pos.ORGANIZATION_STRUCTURE_ID

AND POSV.DATE_FROM = (SELECT MAX(POSV1.DATE_FROM)

FROM PER_ORG_STRUCTURE_VERSIONS POSV1

WHERE POSV1.ORGANIZATION_STRUCTURE_ID = POSV.ORGANIZATION_STRUCTURE_ID))

START WITH POSE.ORGANIZATION_ID_PARENT = (TO_NUMBER(FND_PROFILE.VALUE('PER_BUSINESS_GROUP_I D')))

CONNECT BY PRIOR POSE.ORGANIZATION_ID_CHILD = POSE.ORGANIZATION_ID_PARENT

[debasisdas]

since you have posted a question in the article section it is being moved to Oracle Forum.

[debasisdas]

what exactly is your question

please follow posting guidelines .

please post your questions clearly

do not expect others to guess and solve your problem.