DBA Data[Home] [Help]

APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_INPUT_VALUES_F

Line 981: ,pay_input_values_f piv

977: SELECT pet.element_type_id
978: ,piv.input_value_id
979: ,pel.element_link_id
980: FROM pay_element_types_f pet
981: ,pay_input_values_f piv
982: ,pay_element_links_f pel
983: WHERE pet.element_name = 'Tax Card'
984: AND pet.legislation_code = 'SE'
985: AND piv.element_type_id = pet.element_type_id

Line 2191: ,pay_input_values_f piv

2187: SELECT pet.element_type_id
2188: ,piv.input_value_id
2189: ,pel.element_link_id
2190: FROM pay_element_types_f pet
2191: ,pay_input_values_f piv
2192: ,pay_element_links_f pel
2193: WHERE pet.element_name = 'Tax Card'
2194: AND pet.legislation_code = 'SE'
2195: AND piv.element_type_id = pet.element_type_id

Line 2390: ,pay_input_values_f piv

2386: ,pee.effective_start_date
2387: ,pee.effective_end_date
2388: ,peev.screen_entry_value
2389: FROM pay_element_entries_f pee
2390: ,pay_input_values_f piv
2391: ,pay_element_entry_values_f peev
2392: WHERE pee.element_entry_id = csr_v_ee_id
2393: AND piv.element_type_id = piv.element_type_id
2394: AND piv.NAME = 'RSV Code'