DBA Data[Home] [Help]

APPS.PER_GET_ELIG dependencies on BEN_ELIG_RSLT_F

Line 167: FROM ben_elig_rslt_f RSLT

163: ,OBJ.column_name
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

Line 403: FROM ben_elig_rslt_f RSLT

399: , cp_business_group_id IN NUMBER
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