APPS.PAY_AU_RETRO_UPGRADE dependencies on PAY_DATED_TABLES

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

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 */
277: CURSOR c_get_dated_table_id(c_table_name pay_dated_tables.table_name%TYPE)
278: IS
279: select dated_table_id
280: from pay_dated_tables
281: where table_name = c_table_name;

Line 280: from pay_dated_tables

276: /* Gets the dated_table_id for tables PAY_ELEMENT_ENTRIES_F and PAY_ELEMENT_ENTRY_VALUES_F */
277: CURSOR c_get_dated_table_id(c_table_name pay_dated_tables.table_name%TYPE)
278: IS
279: select dated_table_id
280: from pay_dated_tables
281: where table_name = c_table_name;
282:
283: l_event_group_id NUMBER;
284: l_effective_date DATE;