APPS.ARP_XLA_UPGRADE dependencies on AR120GIR_PERIODS

Line 3156: insert into ar120gir_periods(period_name)

3152:
3153: -- Added for bug 6673937 ( pref. issue)
3154:
3155: BEGIN
3156: insert into ar120gir_periods(period_name)
3157: select
3158: distinct period_name
3159: from gl_periods p
3160: where start_date >= (select min(start_date) from XLA_UPGRADE_DATES)

Line 3165: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');

3161: and end_date <= (select max(end_date) from XLA_UPGRADE_DATES);
3162: EXCEPTION
3163: WHEN NO_DATA_FOUND THEN
3164: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3165: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');
3166: RAISE;
3167:
3168: WHEN OTHERS THEN
3169: -- arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');

Line 3170: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');

3166: RAISE;
3167:
3168: WHEN OTHERS THEN
3169: -- arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3170: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');
3171: RAISE;
3172: END;
3173:
3174:

Line 3338: from ar120gir_periods periods

3334: XLA_DISTRIBUTION_LINKS LNK,
3335: XLA_AE_LINES LN
3336: WHERE EXISTS
3337: (select /*+ PUSH_SUBQ */ null
3338: from ar120gir_periods periods
3339: where periods.period_name = GHD.period_name
3340: )
3341: AND GIMP.JE_HEADER_ID = GHD.JE_HEADER_ID
3342: AND GHD.JE_SOURCE = 'Receivables'

Line 3392: from ar120gir_periods periods

3388: XLA_DISTRIBUTION_LINKS LNK,
3389: XLA_AE_LINES LN
3390: WHERE EXISTS
3391: (select /*+ PUSH_SUBQ */ null
3392: from ar120gir_periods periods
3393: where periods.period_name = GHD.period_name
3394: )
3395: AND GIMP.JE_HEADER_ID = GHD.JE_HEADER_ID
3396: AND GHD.JE_SOURCE = 'Receivables'