DBA Data[Home] [Help]

APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_ELEMENT_LINKS_F

Line 988: ,pay_element_links_f pel

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
992: AND piv.NAME = 'Tax Card Type'

Line 2207: ,pay_element_links_f pel

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
2211: AND piv.NAME = 'Tax Card Type'

Line 2228: ,pay_element_links_f pel

2224: IS
2225: SELECT pet.element_type_id
2226: ,pel.element_link_id
2227: FROM pay_element_types_f pet
2228: ,pay_element_links_f pel
2229: WHERE pet.element_name = csr_v_element_name
2230: AND pet.legislation_code = 'SE'
2231: AND pel.element_type_id = pet.element_type_id
2232: AND pel.business_group_id = g_business_group_id

Line 2335: ,pay_element_links_f pel

2331: SELECT pet.element_type_id
2332: ,pel.element_link_id
2333: ,pee.element_entry_id
2334: FROM pay_element_types_f pet
2335: ,pay_element_links_f pel
2336: ,pay_element_entries_f pee
2337: WHERE pel.element_type_id = pet.element_type_id
2338: AND (pet.legislation_code = 'SE' OR pet.legislation_code IS NULL
2339: )