DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_PYSA dependencies on PER_ALL_PEOPLE_F

Line 687: per_all_people_f ppf,

683: paf.position_id pos_id,
684: paf.grade_id grade_id,
685: paf.business_group_id bus_grp_id
686: FROM per_assignments_f paf,
687: per_all_people_f ppf,
688: per_periods_of_service pps
689: WHERE paf.person_id = ppf.person_id
690: AND paf.assignment_id = p_assignment_id
691: AND pps.person_id = ppf.person_id

Line 814: l_nationality per_all_people_f.nationality%TYPE;

810: rec_person_details csr_person_details%ROWTYPE;
811: rec_primary_address csr_primary_address%ROWTYPE;
812: rec_employer_address csr_employer_address%ROWTYPE;
813: rec_org_address csr_organization_address%ROWTYPE;
814: l_nationality per_all_people_f.nationality%TYPE;
815: l_position per_all_positions.name%TYPE;
816: l_hire_date per_periods_of_service.date_start%TYPE;
817: l_grade per_grades.name%TYPE;
818: l_currency hr_organization_information.org_information10%TYPE;

Line 1816: ,per_all_people_f per

1812: SELECT ee.effective_start_date
1813: ,eev1.screen_entry_value screen_entry_value
1814: FROM per_all_assignments_f asg1
1815: ,per_all_assignments_f asg2
1816: ,per_all_people_f per
1817: ,pay_element_links_f el
1818: ,pay_element_types_f et
1819: ,pay_input_values_f iv1
1820: ,pay_element_entries_f ee