APPS.PAY_GTNLOD_PKG dependencies on HR_LOCATIONS

Line 140: l_location_id hr_locations.location_id%type;

136: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
137: l_gre_name hr_organization_units.name%type;
138: l_organization_id hr_organization_units.organization_id%type;
139: l_org_name hr_organization_units.name%type;
140: l_location_id hr_locations.location_id%type;
141: l_location_code hr_locations.location_code%type;
142: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
143: l_bal_value number(20,2);
144: l_leg_param varchar2(240);

Line 141: l_location_code hr_locations.location_code%type;

137: l_gre_name hr_organization_units.name%type;
138: l_organization_id hr_organization_units.organization_id%type;
139: l_org_name hr_organization_units.name%type;
140: l_location_id hr_locations.location_id%type;
141: l_location_code hr_locations.location_code%type;
142: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%type;
143: l_bal_value number(20,2);
144: l_leg_param varchar2(240);
145: l_leg_start_date date;

Line 2357: from hr_locations_all hrl,

2353: paf.location_id location_id,
2354: hrl.location_code location_code
2355: ,paf.assignment_number assignment_number -- #1937448
2356: ,paf.person_id person_id
2357: from hr_locations_all hrl,
2358: hr_all_organization_units hou1,
2359: hr_all_organization_units hou,
2360: per_assignments_f paf,
2361: pay_payroll_actions ppa,

Line 2635: from hr_locations_all hrl,

2631: hrl.location_code location_code
2632: ,paf.assignment_number assignment_number -- #1937448
2633: ,paf.person_id person_id
2634: ,paa.chunk_number chunk_number
2635: from hr_locations_all hrl,
2636: hr_all_organization_units hou1,
2637: hr_all_organization_units hou,
2638: per_assignments_f paf,
2639: pay_payroll_actions ppa,