DBA Data[Home] [Help]

APPS.BEN_CWB_POST_PROCESS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 913: , pay_element_entry_values_f entval

909: SELECT ele.element_entry_id
910: ,ele.element_type_id
911: FROM per_pay_bases bas
912: , pay_element_entries_f ele
913: , pay_element_entry_values_f entval
914: WHERE bas.pay_basis_id = v_pay_basis_id
915: AND entval.input_value_id = bas.input_value_id
916: AND v_effective_date BETWEEN entval.effective_start_date AND entval.effective_end_date
917: AND ele.assignment_id = v_assignmnet_id

Line 1093: pay_element_entry_values_f eev

1089: ,v_effective_date IN DATE)
1090: IS
1091: select eev.screen_entry_value
1092: from pay_element_entries_f ee,
1093: pay_element_entry_values_f eev
1094: where ee.assignment_id = v_assignment_id
1095: and ee.element_type_id = v_element_type_id
1096: and v_effective_date between ee.effective_start_date and ee.effective_end_date
1097: and eev.element_entry_id = ee.element_entry_id