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.HR_NL_ORG_INFO dependencies on DUAL

Line 11: FROM dual

7: --
8: CURSOR org_hierarchy(p_org_id NUMBER) IS
9: SELECT p_org_id organization_id_parent
10: ,0 lev
11: FROM dual
12: UNION
13: SELECT organization_id_parent
14: ,level
15: FROM

Line 280: FROM dual

276: --
277: CURSOR org_named_hierarchy(vp_Organization_ID NUMBER) IS
278: SELECT vp_Organization_ID Organization_id,
279: 0 lev
280: FROM dual
281: UNION
282: SELECT organization_id_parent
283: ,level lev
284: FROM

Line 344: -- ordering the records by the si class order (A record for a Individual SI type would be

340:
341:
342: --
343: -- Cursor which fetches Social Insurance Provider overridden at the Assignment Level
344: -- ordering the records by the si class order (A record for a Individual SI type would be
345: -- ordered higher than a AMI record).
346: CURSOR asg_provider
347: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS
348: select pae.aei_information8 provider,

Line 367: -- and then by the si class order(A record for a Individual SI type would be

363:
364: --
365: -- Cursor which fetches Social Insurance Provider for the given Hr Organization
366: -- and which offers si class ordering the records first by the Primary provider Flag
367: -- and then by the si class order(A record for a Individual SI type would be
368: -- ordered higher than a AMI record).
369: CURSOR org_uwv_provider
370: (l_org_id in hr_organization_units.organization_id%type,
371: l_uwv_id in hr_organization_units.organization_id%type,

Line 488: -- ordering the records by the si class order (A record for a Individual SI type would be

484:
485:
486: --
487: -- Cursor which fetches Social Insurance Provider overridden at the Assignment Level
488: -- ordering the records by the si class order (A record for a Individual SI type would be
489: -- ordered higher than a AMI record).
490: CURSOR asg_provider
491: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS
492: select pae.aei_information8 provider,

Line 512: -- and then by the si class order(A record for a Individual SI type would be

508:
509: --
510: -- Cursor which fetches Social Insurance Provider for the given Hr Organization
511: -- and which offers SI type ordering the records first by the Primary provider Flag
512: -- and then by the si class order(A record for a Individual SI type would be
513: -- ordered higher than a AMI record).
514: CURSOR org_uwv_provider
515: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2) IS
516: select

Line 718: -- ordering the records by the si class order (A record for a Individual SI type would be

714: FUNCTION Get_Asg_SII_Info_ID
715: (p_assignment_id NUMBER,p_si_type VARCHAR2) RETURN NUMBER IS
716: --
717: -- Cursor which fetches Social Insurance Provider overridden at the Assignment Level
718: -- ordering the records by the si class order (A record for a Individual SI type would be
719: -- ordered higher than a AMI record).
720: CURSOR asg_provider
721: (l_assgn_id NUMBER,l_si_type varchar2) IS
722: select pae.assignment_extra_info_id,

Line 870: SELECT l_org_id tax_org_id,0 lev from dual

866: --
867: CURSOR tax_org_hierarchy(l_org_struct_version_id in per_org_structure_versions.org_structure_version_id%type,
868: l_org_id in hr_organization_units.organization_id%type) IS
869: SELECT tax_org_id,lev from hr_organization_information e,(
870: SELECT l_org_id tax_org_id,0 lev from dual
871: UNION
872: SELECT distinct organization_id_parent
873: ,level
874: FROM (

Line 1329: -- ordering the records by the si class order (A record for a Individual SI type would be

1325:
1326:
1327: --
1328: -- Cursor which fetches Social Insurance Provider overridden at the Assignment Level
1329: -- ordering the records by the si class order (A record for a Individual SI type would be
1330: -- ordered higher than a AMI record).
1331: CURSOR asg_provider
1332: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2,l_assgn_id NUMBER) IS
1333: select pae.aei_information8 provider,

Line 1353: -- and then by the si class order(A record for a Individual SI type would be

1349:
1350: --
1351: -- Cursor which fetches Social Insurance Provider for the given Hr Organization
1352: -- and which offers SI type ordering the records first by the Primary provider Flag
1353: -- and then by the si class order(A record for a Individual SI type would be
1354: -- ordered higher than a AMI record).
1355: CURSOR org_uwv_provider
1356: (l_org_id in hr_organization_units.organization_id%type,l_si_type varchar2) IS
1357: select

Line 1486: select to_number(p_top_org_id) employer from dual;

1482: start with pose.organization_id_parent = p_top_org_id
1483: connect by prior pose.organization_id_child = pose.organization_id_parent
1484: and pose.org_structure_version_id = p_Org_Struct_Version_Id
1485: union
1486: select to_number(p_top_org_id) employer from dual;
1487:
1488: emp_list varchar2(1000);
1489:
1490: begin

Line 2179: SELECT l_org_id iza_org_id,0 lev from dual

2175: --
2176: CURSOR iza_org_hierarchy(l_org_struct_version_id in per_org_structure_versions.org_structure_version_id%type,
2177: l_org_id in hr_organization_units.organization_id%type) IS
2178: SELECT iza_org_id,lev from hr_organization_information e,(
2179: SELECT l_org_id iza_org_id,0 lev from dual
2180: UNION
2181: SELECT distinct organization_id_parent
2182: ,level
2183: FROM per_org_structure_elements pose