DBA Data[Home] [Help]

APPS.GHR_PER_SUM dependencies on PAY_INPUT_VALUES_F

Line 509: ,pay_input_values_f ipv

505: IS
506: SELECT eev.screen_entry_value
507: ,eev.effective_start_date
508: FROM pay_element_types_f elt
509: ,pay_input_values_f ipv
510: ,pay_element_entries_f ele
511: ,pay_element_entry_values_f eev
512: WHERE p_effective_date BETWEEN elt.effective_start_date AND elt.effective_end_date
513: AND p_effective_date BETWEEN ipv.effective_start_date AND ipv.effective_end_date

Line 638: ,pay_input_values_f ipv

634: CURSOR cur_ele_values IS
635: SELECT eev.screen_entry_value
636: ,eev.effective_start_date
637: FROM pay_element_entry_values_f eev
638: ,pay_input_values_f ipv
639: WHERE p_input_value_name = ipv.name
640: AND p_effective_date BETWEEN ipv.effective_start_date AND ipv.effective_end_date
641: AND ipv.input_value_id = eev.input_value_id
642: AND p_element_entry_id = eev.element_entry_id