APPS.PAY_GTNLOD_PKG dependencies on HR_LOCATIONS

Line 164: l_location_id hr_locations.location_id%type;

160: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
161: l_gre_name hr_organization_units.name%type;
162: l_organization_id hr_organization_units.organization_id%type;
163: l_org_name hr_organization_units.name%type;
164: l_location_id hr_locations.location_id%type;
165: l_location_code hr_locations.location_code%type;
166: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
167: l_bal_value number(20,2);
168: l_leg_param varchar2(240);

Line 165: l_location_code hr_locations.location_code%type;

161: l_gre_name hr_organization_units.name%type;
162: l_organization_id hr_organization_units.organization_id%type;
163: l_org_name hr_organization_units.name%type;
164: l_location_id hr_locations.location_id%type;
165: l_location_code hr_locations.location_code%type;
166: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
167: l_bal_value number(20,2);
168: l_leg_param varchar2(240);
169: l_leg_start_date date;

Line 2540: from hr_locations_all hrl,

2536: paf.location_id location_id,
2537: hrl.location_code location_code
2538: ,paf.assignment_number assignment_number -- #1937448
2539: ,paf.person_id person_id
2540: from hr_locations_all hrl,
2541: hr_all_organization_units hou1,
2542: hr_all_organization_units hou,
2543: per_assignments_f paf,
2544: pay_payroll_actions ppa,

Line 2847: from hr_locations_all hrl,

2843: hrl.location_code location_code
2844: ,paf.assignment_number assignment_number -- #1937448
2845: ,paf.person_id person_id
2846: ,paa.chunk_number chunk_number
2847: from hr_locations_all hrl,
2848: hr_all_organization_units hou1,
2849: hr_all_organization_units hou,
2850: per_assignments_f paf,
2851: pay_payroll_actions ppa,