DBA Data[Home] [Help]

APPS.PAY_US_INV_DED_FORMULAS dependencies on PAY_INPUT_VALUES_F

Line 546: pay_input_values_f pivf

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
550: and pivf.name = c_input_value_name

Line 562: pay_input_values_f pivf_si,

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
566: and peef_base.element_type_id = pet_base.element_type_id

Line 3258: pay_input_values_f pivf

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
3262: and pivf.name = c_input_value_name