APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_ELEMENT_TYPES_F

Line 986: FROM pay_element_types_f pet

982: IS
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'

Line 2205: FROM pay_element_types_f pet

2201: IS
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'

Line 2227: FROM pay_element_types_f pet

2223: CURSOR csr_get_element_type_id (csr_v_element_name VARCHAR2)
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

Line 2334: FROM pay_element_types_f pet

2330: IS
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

Line 2383: ,pay_element_types_f pet

2379: ,pet.element_name
2380: ,pee.effective_start_date
2381: ,pee.effective_end_date
2382: FROM pay_element_entries_f pee
2383: ,pay_element_types_f pet
2384: WHERE pet.element_name = 'Car Benefit'
2385: AND pet.legislation_code = 'SE'
2386: AND pee.assignment_id = csr_v_assignment_id
2387: AND pee.element_type_id = pet.element_type_id