APPS.GHR_EXEMP_PURGE dependencies on BEN_PRTT_RT_VAL

Line 472: ELEMENT_ENTRY_VALUE_ID IN (SELECT ELEMENT_ENTRY_VALUE_ID FROM BEN_PRTT_RT_VAL WHERE PRTT_ENRT_RSLT_ID

468:
469: DELETE FROM PAY_ELEMENT_ENTRIES_F
470: WHERE ELEMENT_ENTRY_ID IN
471: (SELECT ELEMENT_ENTRY_ID FROM PAY_ELEMENT_ENTRY_VALUES_F WHERE
472: ELEMENT_ENTRY_VALUE_ID IN (SELECT ELEMENT_ENTRY_VALUE_ID FROM BEN_PRTT_RT_VAL WHERE PRTT_ENRT_RSLT_ID
473: IN (SELECT PRTT_ENRT_RSLT_ID FROM BEN_PRTT_ENRT_RSLT_F WHERE PERSON_ID =
474: P_PERSON_ID)));
475:
476: DELETE FROM PAY_ELEMENT_ENTRY_VALUES_F

Line 478: (SELECT ELEMENT_ENTRY_VALUE_ID FROM BEN_PRTT_RT_VAL

474: P_PERSON_ID)));
475:
476: DELETE FROM PAY_ELEMENT_ENTRY_VALUES_F
477: WHERE ELEMENT_ENTRY_VALUE_ID IN
478: (SELECT ELEMENT_ENTRY_VALUE_ID FROM BEN_PRTT_RT_VAL
479: WHERE PRTT_ENRT_RSLT_ID IN (SELECT PRTT_ENRT_RSLT_ID FROM BEN_PRTT_ENRT_RSLT_F WHERE PERSON_ID =
480: P_PERSON_ID));
481:
482: BEN_PERSON_DELETE.DELETE_BEN_ROWS (p_person_id => p_person_id);