APPS.PAY_US_LOC_CHANGE dependencies on PER_PEOPLE_F

Line 98: per_people_f ppf,

94: paf.assignment_number
95: FROM
96: hr_organization_units hou,
97: hr_soft_coding_keyflex hsck,
98: per_people_f ppf,
99: per_assignments_f paf
100: WHERE
101: paf.assignment_id = p_assignment_id
102: AND paf.person_id = ppf.person_id

Line 107: from per_people_f ppf_inner

103: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id
104: AND hsck.segment1 = hou.organization_id
105: -- Changing the cursor to pick up the most recent date
106: AND ppf.effective_start_date = (select max(ppf_inner.effective_start_date)
107: from per_people_f ppf_inner
108: where ppf_inner.person_id = ppf.person_id) ;
109: /* cursor to get location code */
110:
111: CURSOR csr_location_code

Line 240: l_full_name per_people_f.full_name%type;

236: l_ret_text varchar2(1000);
237: l_assignment_id per_assignments_f.assignment_id%type;
238: l_gre_name hr_tax_units_v.name%type;
239: l_location_code hr_locations.location_code%type;
240: l_full_name per_people_f.full_name%type;
241: l_assignment_number per_assignments_f.assignment_number%type;
242: l_location_id number;
243: l_error varchar2(1000);
244: l_assignment_status varchar2(1);