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.PER_NL_FDR_ARCHIVE dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 360: FROM per_org_structure_elements pose

356: where posv.organization_structure_id=p_org_struct_id
357: and p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
358: and (paa.organization_id in
359: ((SELECT pose.organization_id_child
360: FROM per_org_structure_elements pose
361: WHERE pose.org_structure_version_id = posv.org_structure_version_id
362: START with pose.organization_id_parent = p_org_id
363: CONNECT BY prior organization_id_child = organization_id_parent)
364: UNION

Line 444: from per_org_structure_elements pose

440: OR
441: per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 1)
442: and paa.organization_id in
443: (select pose.organization_id_parent
444: from per_org_structure_elements pose
445: where posv.org_structure_version_id = pose.org_structure_version_id
446: UNION
447: select pose.organization_id_child
448: from per_org_structure_elements pose

Line 448: from per_org_structure_elements pose

444: from per_org_structure_elements pose
445: where posv.org_structure_version_id = pose.org_structure_version_id
446: UNION
447: select pose.organization_id_child
448: from per_org_structure_elements pose
449: where posv.org_structure_version_id = pose.org_structure_version_id);
450:
451:
452: EXCEPTION

Line 552: FROM per_org_structure_elements pose,per_org_structure_versions posv

548: AND hoi1.org_information3 IS NOT NULL
549: AND hou1.organization_id in
550:
551: (SELECT pose.organization_id_parent
552: FROM per_org_structure_elements pose,per_org_structure_versions posv
553: WHERE posv.org_structure_version_id = pose.org_structure_version_id
554: AND posv.organization_structure_id=p_org_struct_id
555: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
556:

Line 560: FROM per_org_structure_elements pose,per_org_structure_versions posv

556:
557: UNION
558:
559: SELECT pose.organization_id_child
560: FROM per_org_structure_elements pose,per_org_structure_versions posv
561: WHERE posv.org_structure_version_id = pose.org_structure_version_id
562: AND posv.organization_structure_id=p_org_struct_id
563: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time))
564:

Line 578: FROM per_org_structure_elements pose,per_org_structure_versions posv

574: AND hoi2.org_information2 IS NOT NULL
575: AND hou2.organization_id in
576:
577: (SELECT pose.organization_id_parent
578: FROM per_org_structure_elements pose,per_org_structure_versions posv
579: WHERE posv.org_structure_version_id = pose.org_structure_version_id
580: AND posv.organization_structure_id=p_org_struct_id
581: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
582:

Line 586: FROM per_org_structure_elements pose,per_org_structure_versions posv

582:
583: UNION
584:
585: SELECT pose.organization_id_child
586: FROM per_org_structure_elements pose,per_org_structure_versions posv
587: WHERE posv.org_structure_version_id = pose.org_structure_version_id
588: AND posv.organization_structure_id=p_org_struct_id
589: AND p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time))
590:

Line 729: FROM per_org_structure_elements pose

725: where posv.organization_structure_id=p_org_struct_id
726: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
727: and (paa.organization_id in
728: ((SELECT pose.organization_id_child
729: FROM per_org_structure_elements pose
730: WHERE pose.org_structure_version_id = posv.org_structure_version_id
731: START with pose.organization_id_parent = p_org_id
732: CONNECT BY prior organization_id_child = organization_id_parent)
733: UNION

Line 815: from per_org_structure_elements pose

811: OR
812: per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 1)
813: and paa.organization_id in
814: (select pose.organization_id_parent
815: from per_org_structure_elements pose
816: where posv.org_structure_version_id = pose.org_structure_version_id
817: UNION
818: select pose.organization_id_child
819: from per_org_structure_elements pose

Line 819: from per_org_structure_elements pose

815: from per_org_structure_elements pose
816: where posv.org_structure_version_id = pose.org_structure_version_id
817: UNION
818: select pose.organization_id_child
819: from per_org_structure_elements pose
820: where posv.org_structure_version_id = pose.org_structure_version_id);
821:
822:
823: l_report_date VARCHAR2(100);

Line 1348: from per_org_structure_elements pose

1344: and hr_nl_org_info.get_tax_org_id(posv.org_structure_version_id,paa.organization_id) is null
1345: and per_nl_fdr_archive.org_check(pap.business_group_id, null, nvl(paa.establishment_id,-1), to_date(p_report_date,'RRRR/MM/DD')) = 0
1346: and paa.organization_id in
1347: (select pose.organization_id_parent
1348: from per_org_structure_elements pose
1349: where posv.org_structure_version_id = pose.org_structure_version_id
1350: UNION
1351: select pose.organization_id_child
1352: from per_org_structure_elements pose

Line 1352: from per_org_structure_elements pose

1348: from per_org_structure_elements pose
1349: where posv.org_structure_version_id = pose.org_structure_version_id
1350: UNION
1351: select pose.organization_id_child
1352: from per_org_structure_elements pose
1353: where posv.org_structure_version_id = pose.org_structure_version_id);
1354:
1355:
1356: l_bg_name VARCHAR2(100);