DBA Data[Home] [Help]

APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on PAY_ELEMENT_ENTRIES_F

Line 1652: -- PAY_ELEMENT_ENTRIES_F (PEE)

1648: -- BEN_PER_CM_F (PCM) (join to pil to check status)
1649: -- BEN_PER_CM_USG_F (PCU) (join to pil to check status)
1650: -- BEN_PER_CM_TRGR_F (PCR) (join to pil to check status)
1651: -- BEN_PER_CM_PRVDD_F (PCD) (join to pil to check status)
1652: -- PAY_ELEMENT_ENTRIES_F (PEE)
1653: -- PAY_ELEMENT_ENTRY_VALUES_F (PEV)
1654: -- BEN_PRTT_PREM_F (PPE)
1655: -- BEN_CBR_QUALD_BNF (CQB) - (not deleted, if it is the initial qualifying event, join
1656: -- to pil to check status. If it is not the initial

Line 2663: from pay_element_entries_f pee,

2659: select pee.element_entry_id,
2660: pee.effective_start_date,
2661: pee.effective_end_date,
2662: pee.object_version_number
2663: from pay_element_entries_f pee,
2664: pay_element_entry_values_f pev
2665: where pev.element_entry_value_id = p_element_entry_value_id
2666: and pev.element_entry_id = pee.element_entry_id
2667: order by pee.effective_start_date;