DBA Data[Home] [Help]

APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_ELEMENT_LINKS_F

Line 982: ,pay_element_links_f pel

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

Line 2192: ,pay_element_links_f pel

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

Line 2213: ,pay_element_links_f pel

2209: IS
2210: SELECT pet.element_type_id
2211: ,pel.element_link_id
2212: FROM pay_element_types_f pet
2213: ,pay_element_links_f pel
2214: WHERE pet.element_name = csr_v_element_name
2215: AND pet.legislation_code = 'SE'
2216: AND pel.element_type_id = pet.element_type_id
2217: AND pel.business_group_id = g_business_group_id

Line 2320: ,pay_element_links_f pel

2316: SELECT pet.element_type_id
2317: ,pel.element_link_id
2318: ,pee.element_entry_id
2319: FROM pay_element_types_f pet
2320: ,pay_element_links_f pel
2321: ,pay_element_entries_f pee
2322: WHERE pel.element_type_id = pet.element_type_id
2323: AND (pet.legislation_code = 'SE' OR pet.legislation_code IS NULL
2324: )