APPS.BEN_CWB_BACKOUT_POST_PROCESS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 644: pay_element_entry_values_f eev

640: ,v_effective_date IN DATE)
641: IS
642: select eev.screen_entry_value
643: from pay_element_entries_f ee,
644: pay_element_entry_values_f eev
645: where ee.assignment_id = v_assignment_id
646: and ee.element_type_id = v_element_type_id
647: and v_effective_date between ee.effective_start_date and ee.effective_end_date
648: and eev.element_entry_id = ee.element_entry_id

Line 2147: pay_element_entry_values_f pev

2143: pet.processing_type
2144: from pay_element_types_f pet,
2145: pay_element_links_f pel,
2146: pay_element_entries_f pee,
2147: pay_element_entry_values_f pev
2148: where pev.element_entry_value_id = p_element_entry_value_id
2149: and pee.element_entry_id = pev.element_entry_id
2150: and pev.effective_start_date between pee.effective_start_date
2151: and pee.effective_end_date

Line 2176: pay_element_entry_values_f pev

2172: pev.screen_entry_value
2173: from per_all_assignments_f asg,
2174: pay_element_links_f pel,
2175: pay_element_entries_f pee,
2176: pay_element_entry_values_f pev
2177: where asg.person_id = p_person_id
2178: and pee.assignment_id = asg.assignment_id
2179: and p_effective_date between asg.effective_start_date
2180: and asg.effective_end_date

Line 2434: select screen_entry_value from pay_element_entry_values_f

2430: from per_pay_proposals
2431: where pay_proposal_id = l_pay_proposal_id;
2432:
2433: cursor c_element_entry_val(l_element_entry_val_id IN number) is
2434: select screen_entry_value from pay_element_entry_values_f
2435: where element_entry_value_id = l_element_entry_val_id;
2436:
2437: --
2438: --***************audit changes***************--