DBA Data[Home] [Help]

APPS.PAY_GB_ENH_RETRO_PAY dependencies on PAY_ELEMENT_TYPE_RULES

Line 153: pay_element_type_rules petr

149: IS
150: SELECT
151: petr.element_set_id
152: FROM
153: pay_element_type_rules petr
154: WHERE
155: petr.element_type_id = cp_element_type_id
156: AND petr.include_or_exclude = 'I'
157: UNION ALL

Line 178: pay_element_type_rules petr

174: MINUS
175: SELECT
176: petr.element_set_id
177: FROM
178: pay_element_type_rules petr
179: WHERE
180: petr.element_type_id = cp_element_type_id
181: AND petr.include_or_exclude = 'E';
182: CURSOR c_element_check(cp_element_set_id IN NUMBER)

Line 308: pay_element_type_rules petr

304: IS
305: SELECT
306: petr.element_set_id
307: FROM
308: pay_element_type_rules petr
309: WHERE
310: petr.element_type_id = cp_element_type_id
311: AND petr.include_or_exclude = 'I'
312: UNION ALL

Line 333: pay_element_type_rules petr

329: MINUS
330: SELECT
331: petr.element_set_id
332: FROM
333: pay_element_type_rules petr
334: WHERE
335: petr.element_type_id = cp_element_type_id
336: AND petr.include_or_exclude = 'E';
337: CURSOR c_get_business_group(cp_element_set_id IN NUMBER ,cp_legislation_code