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_ALL_ASSIGNMENTS_F

Line 350: from per_all_assignments_f paa,

346: IF p_org_id is not NULL THEN
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

Line 408: from per_all_assignments_f paa,

404:
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

Line 674: from per_all_assignments_f paa,

670: ,p_end_person_id NUMBER
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

Line 718: from per_all_assignments_f paa,

714: ,p_report_date VARCHAR2) is
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,

Line 775: from per_all_assignments_f paa,

771: ,p_payroll_action_id NUMBER) is
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,

Line 931: per_all_assignments_f pas,

927: hou.name org_name,
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

Line 956: per_all_assignments_f pas,

952: hou.name org_name,
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:

Line 987: per_all_assignments_f pas,

983: pap.business_group_id bg_id,
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:

Line 1310: from per_all_assignments_f paa,

1306:
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,