DBA Data[Home] [Help]

APPS.PAY_IP_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPE_RULES

Line 155: from pay_element_type_rules petr

151: cursor c_element_set(cp_element_type_id in number
152: ,cp_classification_id in number
153: ,cp_legislation_code in varchar2) is
154: select petr.element_set_id
155: from pay_element_type_rules petr
156: where petr.element_type_id = cp_element_type_id
157: and petr.include_or_exclude = 'I'
158: union all
159: select pes.element_set_id

Line 171: from pay_element_type_rules petr

167: and pet.element_type_id = cp_element_type_id
168: and pecr.classification_id = cp_classification_id
169: minus
170: select petr.element_set_id
171: from pay_element_type_rules petr
172: where petr.element_type_id = cp_element_type_id
173: and petr.include_or_exclude = 'E';
174:
175: cursor c_element_check(cp_element_set_id in number) is

Line 276: from pay_element_type_rules petr

272: cursor c_element_set(cp_element_type_id in number
273: ,cp_classification_id in number
274: ,cp_legislation_code in varchar2) is
275: select petr.element_set_id
276: from pay_element_type_rules petr
277: where petr.element_type_id = cp_element_type_id
278: and petr.include_or_exclude = 'I'
279: union all
280: select pes.element_set_id

Line 292: from pay_element_type_rules petr

288: and pet.element_type_id = cp_element_type_id
289: and pecr.classification_id = cp_classification_id
290: minus
291: select petr.element_set_id
292: from pay_element_type_rules petr
293: where petr.element_type_id = cp_element_type_id
294: and petr.include_or_exclude = 'E';
295:
296: cursor c_get_business_group(cp_element_set_id in number