DBA Data[Home] [Help]

APPS.PAY_ZA_EOY_VAL dependencies on PER_ALL_POSITIONS

Line 3168: l_pos_location_id per_all_positions.location_id%type;

3164: l_ni per_all_people_f.national_identifier%type;
3165: l_location_id per_all_assignments_f.location_id%type;
3166: l_position_id per_all_assignments_f.position_id%type;
3167: l_organization_id per_all_assignments_f.organization_id%type;
3168: l_pos_location_id per_all_positions.location_id%type;
3169: l_org_location_id hr_all_organization_units.location_id%type;
3170: l_passport_no varchar2(150);
3171: l_country_passport varchar2(150);
3172: l_id_dob number(1);

Line 3236: from per_all_positions pap

3232: ass.location_id,
3233: ass.position_id,
3234: ass.organization_id,
3235: (select pap.location_id
3236: from per_all_positions pap
3237: where pap.position_id = ass.position_id) pos_location_id,
3238: (select haou.location_id
3239: from hr_all_organization_units haou
3240: where haou.organization_id=ass.organization_id) org_location_id