DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 137: ,pay_input_values_f piv

133: SELECT pet.element_type_id element_type_id
134: ,piv.input_value_id input_value_id
135: ,piv.display_sequence indx
136: FROM pay_element_types_f pet
137: ,pay_input_values_f piv
138: WHERE pet.element_name ='Income Tax Challan Information'
139: AND pet.legislation_code='IN'
140: AND pet.element_type_id = piv.element_type_id
141: AND piv.name in('Challan or Voucher Number',

Line 2236: ,pay_input_values_f piv

2232: IS
2233: SELECT peev.screen_entry_value entry_value
2234: ,piv.display_sequence indx
2235: FROM pay_element_entry_values_f peev
2236: ,pay_input_values_f piv
2237: WHERE peev.element_entry_id = p_element_entry_id
2238: AND peev.input_value_id IN(g_input_table_rec(1).input_value_id
2239: ,g_input_table_rec(2).input_value_id
2240: ,g_input_table_rec(3).input_value_id