APPS.PQP_TIAALOD_PKG dependencies on HR_LOCATIONS

Line 16: l_location_id hr_locations.location_id%TYPE;

12: l_tax_unit_id hr_organization_units.organization_id%TYPE;
13: l_gre_name hr_organization_units.name%TYPE;
14: l_organization_id hr_organization_units.organization_id%TYPE;
15: l_org_name hr_organization_units.name%TYPE;
16: l_location_id hr_locations.location_id%TYPE;
17: l_location_code hr_locations.location_code%TYPE;
18: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
19: l_bal_value NUMBER(11,2);
20: l_leg_param VARCHAR2(240);

Line 17: l_location_code hr_locations.location_code%TYPE;

13: l_gre_name hr_organization_units.name%TYPE;
14: l_organization_id hr_organization_units.organization_id%TYPE;
15: l_org_name hr_organization_units.name%TYPE;
16: l_location_id hr_locations.location_id%TYPE;
17: l_location_code hr_locations.location_code%TYPE;
18: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
19: l_bal_value NUMBER(11,2);
20: l_leg_param VARCHAR2(240);
21: l_leg_start_date DATE;

Line 778: FROM hr_locations_all hrl,

774: paf.location_id location_id,
775: hrl.location_code location_code,
776: paa.assignment_action_id assignment_action_id,
777: ppa.payroll_id pay_payroll_id
778: FROM hr_locations_all hrl,
779: hr_organization_units hox,
780: hr_organization_units hou,
781: per_assignments_f paf,
782: pay_payroll_actions ppa,