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_ASSIGNMENT_STATUS_TYPES

Line 351: per_assignment_status_types past,

347: BEGIN
348:
349: select 1 INTO l_return_val
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:

Line 409: per_assignment_status_types past,

405: BEGIN
406:
407: select 1 INTO l_return_val
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:

Line 675: per_assignment_status_types past,

671: ,p_payroll_action_id NUMBER) is
672: select distinct paa.assignment_id assignment_id
673:
674: from per_all_assignments_f paa,
675: per_assignment_status_types past,
676: pay_payroll_actions ppa,
677: per_all_people_f pap,
678: per_periods_of_service ppos
679:

Line 719: per_assignment_status_types past,

715:
716: select distinct paa.assignment_id assignment_id
717:
718: from per_all_assignments_f paa,
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

Line 776: per_assignment_status_types past,

772:
773: select distinct paa.assignment_id assignment_id
774:
775: from per_all_assignments_f paa,
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

Line 932: per_assignment_status_types past,

928: hoi.org_information4 tax_reg
929:
930: from pay_assignment_actions paa,
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:

Line 957: per_assignment_status_types past,

953: hoi.org_information1 tax_reg
954:
955: from pay_assignment_actions paa,
956: per_all_assignments_f pas,
957: per_assignment_status_types past,
958: hr_organization_units hou,
959: hr_organization_information hoi
960:
961: where paa.assignment_action_id = p_assignment_action_id

Line 988: per_assignment_status_types past,

984: pas.establishment_id establishment_id
985:
986: from per_all_people_f pap,
987: per_all_assignments_f pas,
988: per_assignment_status_types past,
989: pay_assignment_actions paa,
990: per_periods_of_service ppos
991:
992: where paa.assignment_action_id = p_assignment_action_id

Line 1311: per_assignment_status_types past,

1307: select distinct pap.employee_number emp_no,
1308: pap.full_name name
1309:
1310: from per_all_assignments_f paa,
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