APPS.PER_GET_ELIG dependencies on PER_ALL_ASSIGNMENTS_F

Line 24: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

20:
21: l_proc VARCHAR2(50);
22: l_per_elig_obj per_elig_obj;
23:
24: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
25: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
26: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
27: l_elig_obj_eff_st_dt ben_elig_obj_f.effective_start_date%TYPE;
28: l_elig_obj_eff_en_dt ben_elig_obj_f.effective_end_date%TYPE;

Line 25: l_business_group_id per_all_assignments_f.business_group_id%TYPE;

21: l_proc VARCHAR2(50);
22: l_per_elig_obj per_elig_obj;
23:
24: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
25: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
26: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
27: l_elig_obj_eff_st_dt ben_elig_obj_f.effective_start_date%TYPE;
28: l_elig_obj_eff_en_dt ben_elig_obj_f.effective_end_date%TYPE;
29: l_column_name ben_elig_obj_f.column_name%TYPE;

Line 47: ' FROM per_all_assignments_f'||

43:
44: -- Cursor to fetch all the effective assignments for the given person
45: OPEN c_per_asg FOR ' SELECT assignment_id,'||
46: ' business_group_id'||
47: ' FROM per_all_assignments_f'||
48: ' WHERE person_id = :1'||
49: ' AND assignment_id = NVL(:2, assignment_id)'||
50: ' AND effective_start_date <= :3'||
51: ' AND effective_end_date >= :4'

Line 246: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

242:
243: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
244: l_person_id per_all_people_f.person_id%TYPE;
245: l_party_id per_all_people_f.party_id%TYPE;
246: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
247: l_asg_eff_st_dt per_all_assignments_f.effective_start_date%TYPE;
248: l_asg_eff_en_dt per_all_assignments_f.effective_end_date%TYPE;
249:
250: -- Cursor to get the ID of the eligibility object

Line 247: l_asg_eff_st_dt per_all_assignments_f.effective_start_date%TYPE;

243: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;
244: l_person_id per_all_people_f.person_id%TYPE;
245: l_party_id per_all_people_f.party_id%TYPE;
246: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
247: l_asg_eff_st_dt per_all_assignments_f.effective_start_date%TYPE;
248: l_asg_eff_en_dt per_all_assignments_f.effective_end_date%TYPE;
249:
250: -- Cursor to get the ID of the eligibility object
251: CURSOR c_elig_obj ( cp_table_name IN VARCHAR2

Line 248: l_asg_eff_en_dt per_all_assignments_f.effective_end_date%TYPE;

244: l_person_id per_all_people_f.person_id%TYPE;
245: l_party_id per_all_people_f.party_id%TYPE;
246: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
247: l_asg_eff_st_dt per_all_assignments_f.effective_start_date%TYPE;
248: l_asg_eff_en_dt per_all_assignments_f.effective_end_date%TYPE;
249:
250: -- Cursor to get the ID of the eligibility object
251: CURSOR c_elig_obj ( cp_table_name IN VARCHAR2
252: , cp_column_name IN VARCHAR2

Line 314: ' FROM per_all_assignments_f'||

310: -- Cursor to fetch assignments for a person
311: OPEN c_asg FOR ' SELECT assignment_id,'||
312: ' effective_start_date,'||
313: ' effective_end_date'||
314: ' FROM per_all_assignments_f'||
315: ' WHERE person_id = :1'||
316: ' AND business_group_id = :2'||
317: ' AND effective_start_date <= :3'||
318: ' AND effective_end_date >= :4'

Line 433: FROM per_all_assignments_f

429: , cp_effective_date IN DATE
430: ) IS
431: SELECT effective_start_date
432: ,effective_end_date
433: FROM per_all_assignments_f
434: WHERE person_id = cp_person_id
435: AND assignment_id = cp_assignment_id
436: AND effective_start_date <= cp_effective_date
437: AND effective_end_date >= cp_effective_date;