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.PAY_DK_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 856: per_all_people_f ppf,

852: paf.position_id pos_id,
853: paf.grade_id grade_id,
854: paf.business_group_id bus_grp_id
855: FROM per_assignments_f paf,
856: per_all_people_f ppf,
857: per_periods_of_service pps
858: WHERE paf.person_id = ppf.person_id
859: AND paf.assignment_id = p_assignment_id
860: AND pps.person_id = ppf.person_id

Line 1044: l_nationality per_all_people_f.nationality%TYPE;

1040: rec_person_details csr_person_details%ROWTYPE;
1041: rec_primary_address csr_primary_address%ROWTYPE;
1042: rec_employer_address csr_employer_address%ROWTYPE;
1043: rec_org_address csr_organization_address%ROWTYPE;
1044: l_nationality per_all_people_f.nationality%TYPE;
1045: l_position per_all_positions.name%TYPE;
1046: l_hire_date per_periods_of_service.date_start%TYPE;
1047: l_grade per_grades.name%TYPE;
1048: l_currency hr_organization_information.org_information10%TYPE;

Line 2658: ,per_all_people_f per

2654: SELECT ee.effective_start_date effective_start_date
2655: ,eev1.screen_entry_value screen_entry_value
2656: FROM per_all_assignments_f asg1
2657: ,per_all_assignments_f asg2
2658: ,per_all_people_f per
2659: ,pay_element_links_f el
2660: ,pay_element_types_f et
2661: ,pay_input_values_f iv1
2662: ,pay_element_entries_f ee