APPS.BEN_PREM_PRTT_MONTHLY dependencies on HR_LOCATIONS_ALL

Line 106: from hr_locations_all loc, per_assignments_f asg

102: l_package varchar2(80) := g_package||'.get_rule_data';
103:
104: cursor csr_asg is
105: select asg.assignment_id, asg.organization_id, loc.region_2, asg.location_id
106: from hr_locations_all loc, per_assignments_f asg
107: where asg.person_id = p_person_id
108: and asg.primary_flag = 'Y'
109: and asg.assignment_type <> 'C'
110: and loc.location_id(+) = asg.location_id

Line 198: from hr_locations_all loc, per_assignments_f asg

194: --l_cbs c_cbs%rowtype;
195:
196: cursor csr_asg is
197: select asg.assignment_id, asg.organization_id, loc.region_2, asg.location_id
198: from hr_locations_all loc, per_assignments_f asg
199: where asg.person_id = p_person_id
200: and asg.assignment_type <> 'C'
201: and asg.primary_flag = 'Y'
202: and loc.location_id(+) = asg.location_id

Line 467: l_region_2 hr_locations_all.region_2%TYPE; -- UTF8 varchar2(70);

463: null;
464: l_assignment_id number;
465: l_location_id number;
466: l_organization_id number;
467: l_region_2 hr_locations_all.region_2%TYPE; -- UTF8 varchar2(70);
468: l_start_or_stop_cd varchar2(30);
469: l_start_or_stop_date date;
470: l_prorate_flag varchar2(30);
471: --