APPS.PAY_US_OVER_LIMIT_TAX_RPT_PKG dependencies on HR_LOCATIONS

Line 128: l_location_id hr_locations.location_id%type;

124: l_tax_unit_id hr_organization_units.organization_id%type;
125: l_gre_name hr_organization_units.name%type;
126: l_organization_id hr_organization_units.organization_id%type;
127: l_org_name hr_organization_units.name%type;
128: l_location_id hr_locations.location_id%type;
129: l_location_code hr_locations.location_code%type;
130: l_leg_param pay_payroll_actions.legislative_parameters%type;--Bug3015312
131: l_leg_start_date date;
132: l_leg_end_date date;

Line 129: l_location_code hr_locations.location_code%type;

125: l_gre_name hr_organization_units.name%type;
126: l_organization_id hr_organization_units.organization_id%type;
127: l_org_name hr_organization_units.name%type;
128: l_location_id hr_locations.location_id%type;
129: l_location_code hr_locations.location_code%type;
130: l_leg_param pay_payroll_actions.legislative_parameters%type;--Bug3015312
131: l_leg_start_date date;
132: l_leg_end_date date;
133: t_gre_id number(15);

Line 1436: from hr_locations_all hrl,

1432: hou1.name organization_name,
1433: paf.location_id location_id,
1434: hrl.location_code location_code,
1435: paf.effective_end_date max_end_date
1436: from hr_locations_all hrl,
1437: hr_all_organization_units hou1,
1438: hr_all_organization_units hou,
1439: per_assignments_f paf,
1440: pay_assignment_actions paa, -- PYUGEN