APPS.BIS_DELEGATION_PUB dependencies on HRI_CL_PER_N_V

Line 227: FROM hri_cl_per_n_v

223: ,cp_date DATE
224: )
225: IS
226: SELECT VALUE
227: FROM hri_cl_per_n_v
228: WHERE ID = cp_person_id
229: AND cp_date BETWEEN effective_start_date AND effective_end_date
230: ;
231: BEGIN

Line 305: FROM hri_cl_per_n_v

301: ,cp_date DATE
302: )
303: IS
304: SELECT VALUE
305: FROM hri_cl_per_n_v
306: WHERE ID = cp_person_id
307: AND cp_date BETWEEN effective_start_date AND effective_end_date
308: ;
309: BEGIN