DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_EVENT_GROUPS

Line 272: FROM pay_event_groups

268:
269: CURSOR c_get_event_group_id
270: IS
271: SELECT event_group_id
272: FROM pay_event_groups
273: WHERE business_group_id = p_business_group_id
274: AND event_group_name = 'AU Enhanced Retro Event Group';
275:
276: /* Gets the dated_table_id for tables PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F */

Line 306: pay_event_groups_api.create_event_group(p_effective_date => l_effective_date

302: /* Checks whether event group already exist */
303: OPEN c_get_event_group_id;
304: FETCH c_get_event_group_id INTO l_event_group_id;
305: IF c_get_event_group_id%NOTFOUND THEN
306: pay_event_groups_api.create_event_group(p_effective_date => l_effective_date
307: ,p_event_group_name => 'AU Enhanced Retro Event Group'
308: ,p_event_group_type => 'R'
309: ,p_business_group_id => p_business_group_id
310: ,p_event_group_id => l_event_group_id