APPS.BEN_PREM_PRTT_MONTHLY dependencies on PER_ASSIGNMENTS_F

Line 112: from hr_locations_all loc, per_assignments_f asg

108: l_package varchar2(80) := g_package||'.get_rule_data';
109:
110: cursor csr_asg is
111: select asg.assignment_id, asg.organization_id, loc.region_2, asg.location_id
112: from hr_locations_all loc, per_assignments_f asg
113: where asg.person_id = p_person_id
114: and asg.primary_flag = 'Y'
115: and asg.assignment_type <> 'C'
116: and loc.location_id(+) = asg.location_id

Line 204: from hr_locations_all loc, per_assignments_f asg

200: --l_cbs c_cbs%rowtype;
201:
202: cursor csr_asg is
203: select asg.assignment_id, asg.organization_id, loc.region_2, asg.location_id
204: from hr_locations_all loc, per_assignments_f asg
205: where asg.person_id = p_person_id
206: and asg.assignment_type <> 'C'
207: and asg.primary_flag = 'Y'
208: and loc.location_id(+) = asg.location_id