DBA Data[Home] [Help]

APPS.PAY_KW_ARCHIVE dependencies on PER_ALL_PEOPLE_F

Line 845: per_all_people_f ppf,

841: paf.grade_id grade_id,
842: ppg.group_name group_name,
843: paf.business_group_id bus_grp_id
844: FROM per_assignments_f paf,
845: per_all_people_f ppf,
846: per_periods_of_service pps,
847: pay_people_groups ppg
848: WHERE paf.person_id = ppf.person_id
849: AND paf.assignment_id = p_assignment_id

Line 980: l_nationality per_all_people_f.nationality%TYPE;

976: rec_person_details csr_person_details%ROWTYPE;
977: rec_primary_address csr_primary_address%ROWTYPE;
978: rec_employer_address csr_employer_address%ROWTYPE;
979: rec_org_address csr_organization_address%ROWTYPE;
980: l_nationality per_all_people_f.nationality%TYPE;
981: l_position per_all_positions.name%TYPE;
982: l_grade per_grades.name%TYPE;
983: l_job per_jobs.name%TYPE;
984: l_currency hr_organization_information.org_information10%TYPE;