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_VERSIONS

Line 354: per_org_structure_versions posv

350: from per_all_assignments_f paa,
351: per_assignment_status_types past,
352: per_all_people_f pap,
353: per_periods_of_service ppos,
354: per_org_structure_versions posv
355:
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

Line 412: per_org_structure_versions posv

408: from per_all_assignments_f paa,
409: per_assignment_status_types past,
410: per_all_people_f pap,
411: per_periods_of_service ppos,
412: per_org_structure_versions posv
413:
414: where posv.organization_structure_id=p_org_struct_id
415: and p_report_date between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
416: and paa.person_id = p_person_id

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 723: per_org_structure_versions posv

719: per_assignment_status_types past,
720: per_all_people_f pap,
721: pay_payroll_actions ppa,
722: per_periods_of_service ppos,
723: per_org_structure_versions posv
724:
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

Line 780: per_org_structure_versions posv

776: per_assignment_status_types past,
777: per_all_people_f pap,
778: pay_payroll_actions ppa,
779: per_periods_of_service ppos,
780: per_org_structure_versions posv
781:
782: where posv.organization_structure_id=p_org_struct_id
783: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
784: and pap.person_id between p_start_person_id and p_end_person_id

Line 935: per_org_structure_versions posv

931: per_all_assignments_f pas,
932: per_assignment_status_types past,
933: hr_organization_units hou,
934: hr_organization_information hoi,
935: per_org_structure_versions posv
936:
937: where posv.organization_structure_id=p_org_struct_id
938: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
939: and paa.assignment_action_id = p_assignment_action_id

Line 1315: per_org_structure_versions posv

1311: per_assignment_status_types past,
1312: per_all_people_f pap,
1313: pay_payroll_actions ppa,
1314: per_periods_of_service ppos,
1315: per_org_structure_versions posv
1316:
1317: where posv.organization_structure_id=p_org_struct_id
1318: and to_date(p_report_date,'RRRR/MM/DD') between posv.date_from and nvl(posv.date_to,hr_general.end_of_time)
1319: and pap.business_group_id = ppa.business_group_id