eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRFASTANSWERS dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 967: from per_org_structure_elements ose

963: is
964: cursor c_toporg
965: is
966: select ose.organization_id_parent
967: from per_org_structure_elements ose
968: where ose.org_structure_element_id = GetOrgStructElement;
969:
970: cursor c_main
971: ( cp_organization_id Number

Line 978: from per_org_structure_elements ele

974: is
975: select TREE.organization_id_start
976: from hr_organization_units org
977: , (select ele.organization_id_parent organization_id_start
978: from per_org_structure_elements ele
979: where cp_organization_process in ('ISNR', 'ISRO')
980: connect by prior ele.organization_id_child = ele.organization_id_parent
981: and ele.org_structure_version_id = cp_org_structure_version_id
982: start with ele.organization_id_parent = cp_organization_id

Line 989: from per_org_structure_elements ele

985: UNION
986: select TREE.organization_id_start
987: from hr_organization_units org
988: , (select ele.organization_id_child organization_id_start
989: from per_org_structure_elements ele
990: where cp_organization_process in ('ISNR', 'ISRO')
991: connect by prior ele.organization_id_child = ele.organization_id_parent
992: and ele.org_structure_version_id = cp_org_structure_version_id
993: start with ele.organization_id_parent = cp_organization_id

Line 1012: from per_org_structure_elements ele

1008: , TREE.organization_id_child
1009: from hr_organization_units org
1010: , (select cp_organization_id_start organization_id_group
1011: , ele.organization_id_child organization_id_child
1012: from per_org_structure_elements ele
1013: where cp_organization_process in ('SIRO', 'ISRO')
1014: connect by prior ele.organization_id_child = ele.organization_id_parent
1015: and ele.org_structure_version_id = cp_org_structure_version_id
1016: start with ele.organization_id_parent = cp_organization_id_start

Line 1141: , per_org_structure_elements ose

1137: is
1138: select ose.org_structure_element_id
1139: from per_organization_structures ost
1140: , per_org_structure_versions osv
1141: , per_org_structure_elements ose
1142: where ost.business_group_id = cp_bus_id
1143: and ost.organization_structure_id = cp_str_id
1144: and ost.organization_structure_id = osv.organization_structure_id
1145: and osv.org_structure_version_id = ose.org_structure_version_id

Line 1149: from per_org_structure_elements ose2

1145: and osv.org_structure_version_id = ose.org_structure_version_id
1146: and trunc(sysdate) between nvl(osv.date_from,trunc(sysdate)) and nvl(osv.date_to,sysdate)
1147: and not exists
1148: ( select null
1149: from per_org_structure_elements ose2
1150: where ose2.org_structure_version_id = osv.org_structure_version_id
1151: and ose.organization_id_parent = ose2.organization_id_child );
1152:
1153: l_business_group_id Number := hr_bis.get_sec_profile_bg_id ;