APPS.PAY_IP_ELE_INFO_CAT_UPG dependencies on PAY_ELEMENT_TYPES_F

Line 23: the existing Elements in PAY_ELEMENT_TYPES_F table.

19: Package Name : PAY_IP_ELE_INFO_CAT_UPG
20: Package File Name : payipeleupg.pkb
21:
22: Description : Used for updating the Element Information Category for
23: the existing Elements in PAY_ELEMENT_TYPES_F table.
24:
25: Change List:
26: ------------
27:

Line 68: FROM pay_element_types_f pet,

64: ) AS
65:
66: CURSOR csr_qualified IS
67: SELECT 'Y'
68: FROM pay_element_types_f pet,
69: per_business_groups pbg,
70: hr_legislation_installations hli
71: WHERE pet.element_type_id = p_object_id
72: AND pbg.business_group_id = pet.business_group_id

Line 77: FROM pay_element_types_f pet,

73: AND pbg.legislation_code = hli.legislation_code;
74:
75: CURSOR csr_ele_class_qualified IS
76: SELECT 'Y'
77: FROM pay_element_types_f pet,
78: pay_element_classifications pec
79: WHERE pet.element_type_id = p_object_id
80: AND pec.classification_id = pet.classification_id
81: AND pec.classification_name IN ('Earnings',

Line 95: FROM pay_element_types_f pet

91: CURSOR csr_ele_qualified IS
92: SELECT 'N'
93: FROM dual
94: WHERE EXISTS (SELECT pet.element_information_category
95: FROM pay_element_types_f pet
96: WHERE pet.element_type_id = p_object_id
97: AND pet.element_information_category IS NOT NULL);
98:
99: l_proc_name varchar2(100);

Line 153: FROM pay_element_types_f pet,

149:
150: CURSOR csr_legislation_code IS
151: SELECT upper(pbg.legislation_code),
152: upper(pec.classification_name)
153: FROM pay_element_types_f pet,
154: pay_element_classifications pec,
155: per_business_groups pbg
156: WHERE pet.element_type_id = p_object_id
157: AND pbg.business_group_id = pet.business_group_id

Line 164: FROM pay_element_types_f pet

160:
161: CURSOR csr_ele_class IS
162: SELECT pet.object_version_number,
163: pet.effective_start_date
164: FROM pay_element_types_f pet
165: WHERE pet.element_type_id = p_object_id;
166:
167: lv_legislation_code varchar2(10);
168: lv_classification_name varchar2(50);