DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PAY_ELEMENT_ENTRIES_F

Line 900: , pay_element_entries_f ele

896: IS
897: SELECT ele.element_entry_id
898: ,ele.element_type_id
899: FROM per_pay_bases bas
900: , pay_element_entries_f ele
901: , pay_element_entry_values_f entval
902: WHERE bas.pay_basis_id = v_pay_basis_id
903: AND entval.input_value_id = bas.input_value_id
904: AND v_effective_date BETWEEN entval.effective_start_date AND entval.effective_end_date

Line 1079: from pay_element_entries_f ee,

1075: ,v_input_value_id IN NUMBER
1076: ,v_effective_date IN DATE)
1077: IS
1078: select eev.screen_entry_value
1079: from pay_element_entries_f ee,
1080: pay_element_entry_values_f eev
1081: where ee.assignment_id = v_assignment_id
1082: and ee.element_type_id = v_element_type_id
1083: and v_effective_date between ee.effective_start_date and ee.effective_end_date