DBA Data[Home] [Help]

APPS.PQP_VEHICLE_MILEAGE dependencies on PAY_ELEMENT_TYPES_F

Line 15: from pay_element_types_f pet,

11: CURSOR c_ele_exst (cp_business_group_id NUMBER)
12: IS
13: SELECT element_name
14: ,substr(pete.EEI_INFORMATION1,0,1) ownership
15: from pay_element_types_f pet,
16: pay_element_type_extra_info pete
17: where exists (SELECT 'X'
18: from pay_run_results prr
19: ,pay_assignment_actions paa

Line 40: FROM pay_element_types_f pet

36: ,cp_ownership VARCHAR2
37: )
38: IS
39: SELECT element_name
40: FROM pay_element_types_f pet
41: WHERE NOT EXISTS (SELECT 'X'
42: FROM pay_element_links_f pel
43: WHERE pel.element_type_id=pet.element_type_id
44: AND pel.business_group_id=pet.business_group_id