DBA Data[Home] [Help]

APPS.BEN_BACK_OUT_LIFE_EVENT dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 1305: -- PAY_ELEMENT_ENTRY_VALUES_F (PEV)

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
1309: -- qualifying event, restore the prior eligibility end date.)

Line 2279: pay_element_entry_values_f pev

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;
2283: --