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 629: ,pay_input_values_f ipv

625: CURSOR cur_ele_values IS
626: SELECT eev.screen_entry_value
627: ,eev.effective_start_date
628: FROM pay_element_entry_values_f eev
629: ,pay_input_values_f ipv
630: WHERE p_input_value_name = ipv.name
631: AND p_effective_date BETWEEN ipv.effective_start_date AND ipv.effective_end_date
632: AND ipv.input_value_id = eev.input_value_id
633: AND p_element_entry_id = eev.element_entry_id