APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_EVENT_GROUPS

Line 289: FROM pay_event_groups

285:
286: CURSOR c_get_event_group_id
287: IS
288: SELECT event_group_id
289: FROM pay_event_groups
290: WHERE business_group_id = p_business_group_id
291: AND event_group_name = 'AU Enhanced Retro Event Group';
292:
293: /* Gets the dated_table_id for tables PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F */

Line 323: pay_event_groups_api.create_event_group(p_effective_date => l_effective_date

319:
320: OPEN c_get_event_group_id;
321: FETCH c_get_event_group_id INTO l_event_group_id;
322: IF c_get_event_group_id%NOTFOUND THEN
323: pay_event_groups_api.create_event_group(p_effective_date => l_effective_date
324: ,p_event_group_name => 'AU Enhanced Retro Event Group'
325: ,p_event_group_type => 'R'
326: ,p_business_group_id => p_business_group_id
327: ,p_event_group_id => l_event_group_id

Line 3282: FROM pay_event_groups

3278: /* bug 10388533 - check if Statutory PPL Payment element has retro event group */
3279:
3280: CURSOR c_get_event_group_le IS
3281: SELECT event_group_id
3282: FROM pay_event_groups
3283: WHERE business_group_id is null
3284: AND legislation_code = 'AU'
3285: AND event_group_name = 'AU Retro Enhanced Event Group';
3286:

Line 3296: l_event_group_id pay_event_groups.event_group_id%type;

3292: AND element_name = p_element_name;
3293:
3294:
3295:
3296: l_event_group_id pay_event_groups.event_group_id%type;
3297: l_recalc_eg_count number;
3298:
3299: BEGIN
3300: