APPS.GHR_EXEMP_PURGE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 471: (SELECT ELEMENT_ENTRY_ID FROM PAY_ELEMENT_ENTRY_VALUES_F WHERE

467: hr_utility.set_location('Entering:'|| g_proc, 10);
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:

Line 476: DELETE FROM PAY_ELEMENT_ENTRY_VALUES_F

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
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));