APPS.PAY_SE_INCOME_STATEMENT dependencies on PAY_ELEMENT_TYPES_F

Line 980: FROM pay_element_types_f pet

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

Line 2190: FROM pay_element_types_f pet

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

Line 2212: FROM pay_element_types_f pet

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

Line 2319: FROM pay_element_types_f pet

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

Line 2368: ,pay_element_types_f pet

2364: ,pet.element_name
2365: ,pee.effective_start_date
2366: ,pee.effective_end_date
2367: FROM pay_element_entries_f pee
2368: ,pay_element_types_f pet
2369: WHERE pet.element_name = 'Car Benefit'
2370: AND pet.legislation_code = 'SE'
2371: AND pee.assignment_id = csr_v_assignment_id
2372: AND pee.element_type_id = pet.element_type_id