DBA Data[Home] [Help]

APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_INPUT_VALUES_F

Line 987: ,pay_input_values_f piv

983: SELECT pet.element_type_id
984: ,piv.input_value_id
985: ,pel.element_link_id
986: FROM pay_element_types_f pet
987: ,pay_input_values_f piv
988: ,pay_element_links_f pel
989: WHERE pet.element_name = 'Tax Card'
990: AND pet.legislation_code = 'SE'
991: AND piv.element_type_id = pet.element_type_id

Line 2206: ,pay_input_values_f piv

2202: SELECT pet.element_type_id
2203: ,piv.input_value_id
2204: ,pel.element_link_id
2205: FROM pay_element_types_f pet
2206: ,pay_input_values_f piv
2207: ,pay_element_links_f pel
2208: WHERE pet.element_name = 'Tax Card'
2209: AND pet.legislation_code = 'SE'
2210: AND piv.element_type_id = pet.element_type_id

Line 2405: ,pay_input_values_f piv

2401: ,pee.effective_start_date
2402: ,pee.effective_end_date
2403: ,peev.screen_entry_value
2404: FROM pay_element_entries_f pee
2405: ,pay_input_values_f piv
2406: ,pay_element_entry_values_f peev
2407: WHERE pee.element_entry_id = csr_v_ee_id
2408: AND piv.element_type_id = piv.element_type_id
2409: AND piv.NAME = 'RSV Code'