DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 136: ,pay_input_values_f piv

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

Line 2342: ,pay_input_values_f piv

2338: IS
2339: SELECT peev.screen_entry_value entry_value
2340: ,piv.display_sequence indx
2341: FROM pay_element_entry_values_f peev
2342: ,pay_input_values_f piv
2343: WHERE peev.element_entry_id = p_element_entry_id
2344: AND peev.input_value_id IN(g_input_table_rec(1).input_value_id
2345: ,g_input_table_rec(2).input_value_id
2346: ,g_input_table_rec(3).input_value_id