DBA Data[Home] [Help]

APPS.PAY_US_INV_DED_FORMULAS dependencies on PAY_INPUT_VALUES_F

Line 620: pay_input_values_f pivf

616: CURSOR c_get_allowance_value(c_input_value_name varchar2) IS
617: select peev.screen_entry_value
618: from pay_element_entries_f peef,
619: pay_element_entry_values_f peev,
620: pay_input_values_f pivf
621: where peef.element_entry_id = P_CTX_ELEMENT_ENTRY_ID
622: and peev.element_entry_id = peef.element_entry_id
623: and pivf.element_type_id = peef.element_type_id
624: and pivf.name = c_input_value_name

Line 636: pay_input_values_f pivf_si,

632: select peev_si.screen_entry_value
633: from pay_element_entries_f peef_base,
634: pay_element_entries_f peef_si,
635: pay_element_entry_values_f peev_si,
636: pay_input_values_f pivf_si,
637: pay_element_types_f pet_base,
638: pay_element_types_f pet_si
639: where peef_base.element_entry_id = P_CTX_ELEMENT_ENTRY_ID
640: and peef_base.element_type_id = pet_base.element_type_id

Line 3924: pay_input_values_f pivf

3920: CURSOR c_get_allowance_value(c_input_value_name varchar2) IS
3921: select peev.screen_entry_value
3922: from pay_element_entries_f peef,
3923: pay_element_entry_values_f peev,
3924: pay_input_values_f pivf
3925: where peef.element_entry_id = P_CTX_ELEMENT_ENTRY_ID
3926: and peev.element_entry_id = peef.element_entry_id
3927: and pivf.element_type_id = peef.element_type_id
3928: and pivf.name = c_input_value_name