APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on PER_ALL_ASSIGNMENTS_F

Line 173: ,p_asg_row in per_all_assignments_f%rowtype

169: (p_currepe_row in ben_determine_rates.g_curr_epe_rec
170: := ben_determine_rates.g_def_curr_epe_rec
171: ,p_per_row in per_all_people_F%rowtype
172: := ben_determine_rates.g_def_curr_per_rec
173: ,p_asg_row in per_all_assignments_f%rowtype
174: := ben_determine_rates.g_def_curr_asg_rec
175: ,p_ast_row in per_assignment_status_types%rowtype
176: := ben_determine_rates.g_def_curr_ast_rec
177: ,p_adr_row in per_addresses%rowtype

Line 248: from per_all_assignments_f asg, per_assignment_status_types ast

244: --
245: -- FONM
246: cursor c_asg(cv_effective_date date) is
247: select asg.assignment_id,asg.organization_id
248: from per_all_assignments_f asg, per_assignment_status_types ast
249: where asg.person_id = p_person_id
250: and asg.assignment_type <> 'C'
251: and asg.primary_flag = 'Y'
252: and asg.assignment_status_type_id = ast.assignment_status_type_id(+)

Line 401: from hr_locations_all loc,per_all_assignments_f asg

397: --
398: -- FONM
399: Cursor c_state(cv_effective_date date) is
400: select loc.region_2
401: from hr_locations_all loc,per_all_assignments_f asg
402: where loc.location_id = asg.location_id
403: and asg.person_id = p_person_id
404: and asg.assignment_type <> 'C'
405: and asg.primary_flag = 'Y'