DBA Data[Home] [Help]

APPS.PAY_GB_RETRO_UPGRADE dependencies on PAY_ELEMENT_TYPE_RULES

Line 169: from pay_element_type_rules petr

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

Line 185: from pay_element_type_rules petr

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

Line 359: from pay_element_type_rules petr

355: cursor c_element_set(cp_element_type_id in number
356: ,cp_classification_id in number
357: ,cp_legislation_code in varchar2) is
358: select petr.element_set_id
359: from pay_element_type_rules petr
360: where petr.element_type_id = cp_element_type_id
361: and petr.include_or_exclude = 'I'
362: union all
363: select pes.element_set_id

Line 375: from pay_element_type_rules petr

371: and pet.element_type_id = cp_element_type_id
372: and pecr.classification_id = cp_classification_id
373: minus
374: select petr.element_set_id
375: from pay_element_type_rules petr
376: where petr.element_type_id = cp_element_type_id
377: and petr.include_or_exclude = 'E';
378:
379: cursor c_get_business_group(cp_element_set_id in number