DBA Data[Home] [Help]

APPS.PAY_US_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPE_RULES

Line 170: from pay_element_type_rules petr

166: cursor c_element_set(cp_element_type_id in number
167: ,cp_classification_id in number
168: ,cp_legislation_code in varchar2) is
169: select petr.element_set_id
170: from pay_element_type_rules petr
171: where petr.element_type_id = cp_element_type_id
172: and petr.include_or_exclude = 'I'
173: union all
174: select pes.element_set_id

Line 186: from pay_element_type_rules petr

182: and pet.element_type_id = cp_element_type_id
183: and pecr.classification_id = cp_classification_id
184: minus
185: select petr.element_set_id
186: from pay_element_type_rules petr
187: where petr.element_type_id = cp_element_type_id
188: and petr.include_or_exclude = 'E';
189:
190: cursor c_element_check(cp_element_set_id in number) is

Line 318: from pay_element_type_rules petr

314: cursor c_element_set(cp_element_type_id in number
315: ,cp_classification_id in number
316: ,cp_legislation_code in varchar2) is
317: select petr.element_set_id
318: from pay_element_type_rules petr
319: where petr.element_type_id = cp_element_type_id
320: and petr.include_or_exclude = 'I'
321: union all
322: select pes.element_set_id

Line 334: from pay_element_type_rules petr

330: and pet.element_type_id = cp_element_type_id
331: and pecr.classification_id = cp_classification_id
332: minus
333: select petr.element_set_id
334: from pay_element_type_rules petr
335: where petr.element_type_id = cp_element_type_id
336: and petr.include_or_exclude = 'E';
337:
338: cursor c_get_business_group(cp_element_set_id in number