DBA Data[Home] [Help]

APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on PAY_ELEMENT_ENTRIES_F

Line 1304: -- PAY_ELEMENT_ENTRIES_F (PEE)

1300: -- BEN_PER_CM_F (PCM) (join to pil to check status)
1301: -- BEN_PER_CM_USG_F (PCU) (join to pil to check status)
1302: -- BEN_PER_CM_TRGR_F (PCR) (join to pil to check status)
1303: -- BEN_PER_CM_PRVDD_F (PCD) (join to pil to check status)
1304: -- PAY_ELEMENT_ENTRIES_F (PEE)
1305: -- PAY_ELEMENT_ENTRY_VALUES_F (PEV)
1306: -- BEN_PRTT_PREM_F (PPE)
1307: -- BEN_CBR_QUALD_BNF (CQB) - (not deleted, if it is the initial qualifying event, join
1308: -- to pil to check status. If it is not the initial

Line 2278: from pay_element_entries_f pee,

2274: select pee.element_entry_id,
2275: pee.effective_start_date,
2276: pee.effective_end_date,
2277: pee.object_version_number
2278: from pay_element_entries_f pee,
2279: pay_element_entry_values_f pev
2280: where pev.element_entry_value_id = p_element_entry_value_id
2281: and pev.element_entry_id = pee.element_entry_id
2282: order by pee.effective_start_date;