DBA Data[Home] [Help]

APPS.PAY_US_INV_DED_FORMULAS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 545: pay_element_entry_values_f peev,

541: -- Get the value entered for Allowances Input Value
542: CURSOR c_get_allowance_value(c_input_value_name varchar2) IS
543: select peev.screen_entry_value
544: from pay_element_entries_f peef,
545: pay_element_entry_values_f peev,
546: pay_input_values_f pivf
547: where peef.element_entry_id = P_CTX_ELEMENT_ENTRY_ID
548: and peev.element_entry_id = peef.element_entry_id
549: and pivf.element_type_id = peef.element_type_id

Line 561: pay_element_entry_values_f peev_si,

557: CURSOR c_get_Replace_Amount_val(c_input_value_name varchar2) IS
558: select peev_si.screen_entry_value
559: from pay_element_entries_f peef_base,
560: pay_element_entries_f peef_si,
561: pay_element_entry_values_f peev_si,
562: pay_input_values_f pivf_si,
563: pay_element_types_f pet_base,
564: pay_element_types_f pet_si
565: where peef_base.element_entry_id = P_CTX_ELEMENT_ENTRY_ID

Line 3257: pay_element_entry_values_f peev,

3253:
3254: CURSOR c_get_allowance_value(c_input_value_name varchar2) IS
3255: select peev.screen_entry_value
3256: from pay_element_entries_f peef,
3257: pay_element_entry_values_f peev,
3258: pay_input_values_f pivf
3259: where peef.element_entry_id = P_CTX_ELEMENT_ENTRY_ID
3260: and peev.element_entry_id = peef.element_entry_id
3261: and pivf.element_type_id = peef.element_type_id