DBA Data[Home] [Help]

APPS.PAY_NO_PAYSLIP_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 1280: per_all_people_f ppf,

1276: paf.grade_id grade_id,
1277: paf.business_group_id bus_grp_id,
1278: paf.assignment_number asg_num
1279: FROM per_assignments_f paf,
1280: per_all_people_f ppf,
1281: per_periods_of_service pps
1282: WHERE paf.person_id = ppf.person_id
1283: AND paf.assignment_id = p_assignment_id
1284: AND pps.person_id = ppf.person_id

Line 1457: l_nationality per_all_people_f.nationality%TYPE;

1453: rec_person_details csr_person_details%ROWTYPE;
1454: rec_primary_address csr_primary_address%ROWTYPE;
1455: rec_employer_address csr_employer_address%ROWTYPE;
1456: rec_org_address csr_organization_address%ROWTYPE;
1457: l_nationality per_all_people_f.nationality%TYPE;
1458: l_position per_all_positions.name%TYPE;
1459: l_hire_date per_periods_of_service.date_start%TYPE;
1460: l_grade per_grades.name%TYPE;
1461: l_currency hr_organization_information.org_information10%TYPE;

Line 3853: ,per_all_people_f per

3849: SELECT ee.effective_start_date effective_start_date
3850: ,eev1.screen_entry_value screen_entry_value
3851: FROM per_all_assignments_f asg1
3852: ,per_all_assignments_f asg2
3853: ,per_all_people_f per
3854: ,pay_element_links_f el
3855: ,pay_element_types_f et
3856: ,pay_input_values_f iv1
3857: ,pay_element_entries_f ee