APPS.PER_GET_ELIG dependencies on BEN_ELIG_OBJ_F

Line 26: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;

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;
30: l_column_value ben_elig_obj_f.column_value%TYPE;

Line 27: l_elig_obj_eff_st_dt ben_elig_obj_f.effective_start_date%TYPE;

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;
30: l_column_value ben_elig_obj_f.column_value%TYPE;
31:

Line 28: l_elig_obj_eff_en_dt ben_elig_obj_f.effective_end_date%TYPE;

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;
30: l_column_value ben_elig_obj_f.column_value%TYPE;
31:
32: TYPE cur_type IS REF CURSOR;

Line 29: l_column_name ben_elig_obj_f.column_name%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;
30: l_column_value ben_elig_obj_f.column_value%TYPE;
31:
32: TYPE cur_type IS REF CURSOR;
33: c_per_asg cur_type;

Line 30: l_column_value ben_elig_obj_f.column_value%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;
30: l_column_value ben_elig_obj_f.column_value%TYPE;
31:
32: TYPE cur_type IS REF CURSOR;
33: c_per_asg cur_type;
34: c_elig_obj cur_type;

Line 72: ' FROM ben_elig_obj_f'||

68: ' effective_start_date,'||
69: ' effective_end_date,'||
70: ' column_name,'||
71: ' column_value'||
72: ' FROM ben_elig_obj_f'||
73: ' WHERE table_name = :1'||
74: ' AND effective_start_date <= :2'||
75: ' AND effective_end_date >= :3'||
76: ' AND business_group_id = :4'

Line 168: ,ben_elig_obj_f OBJ

164: ,OBJ.column_value
165: ,OBJ.effective_start_date
166: ,OBJ.effective_end_date
167: FROM ben_elig_rslt_f RSLT
168: ,ben_elig_obj_f OBJ
169: WHERE RSLT.person_id = cp_person_id
170: AND RSLT.assignment_id = NVL(cp_assignment_id, RSLT.assignment_id)
171: AND RSLT.effective_start_date <= cp_effective_date
172: AND RSLT.effective_end_date >= cp_effective_date

Line 243: l_elig_obj_id ben_elig_obj_f.elig_obj_id%TYPE;

239:
240: l_proc VARCHAR2(50);
241: l_per_asg_obj per_asg_obj;
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;

Line 258: FROM ben_elig_obj_f

254: , cp_business_group_id IN NUMBER
255: , cp_effective_date IN DATE
256: ) IS
257: SELECT elig_obj_id
258: FROM ben_elig_obj_f
259: WHERE table_name = cp_table_name
260: AND column_name = cp_column_name
261: AND column_value = cp_column_value
262: AND business_group_id = cp_business_group_id

Line 404: ,ben_elig_obj_f OBJ

400: ) IS
401: SELECT RSLT.person_id
402: ,RSLT.assignment_id
403: FROM ben_elig_rslt_f RSLT
404: ,ben_elig_obj_f OBJ
405: WHERE OBJ.table_name = cp_table_name
406: AND OBJ.column_name = cp_column_name
407: AND OBJ.column_value = cp_column_value
408: AND OBJ.effective_start_date <= cp_effective_date