APPS.PAY_US_LOC_CHANGE dependencies on PER_ASSIGNMENTS_F

Line 99: per_assignments_f paf

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
103: AND paf.soft_coding_keyflex_id = hsck.soft_coding_keyflex_id

Line 237: l_assignment_id per_assignments_f.assignment_id%type;

233: p_location_id in number) is
234:
235: l_ret_code number;
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;

Line 241: l_assignment_number per_assignments_f.assignment_number%type;

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);
245: