APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_DATED_TABLES

Line 294: CURSOR c_get_dated_table_id(c_table_name pay_dated_tables.table_name%TYPE)

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 */
294: CURSOR c_get_dated_table_id(c_table_name pay_dated_tables.table_name%TYPE)
295: IS
296: select dated_table_id
297: from pay_dated_tables
298: where table_name = c_table_name;

Line 297: from pay_dated_tables

293: /* Gets the dated_table_id for tables PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F */
294: CURSOR c_get_dated_table_id(c_table_name pay_dated_tables.table_name%TYPE)
295: IS
296: select dated_table_id
297: from pay_dated_tables
298: where table_name = c_table_name;
299:
300: l_event_group_id NUMBER;
301: l_effective_date DATE;