3151:
3152: -- Added for bug 6673937 ( pref. issue)
3153:
3154: BEGIN
3155: insert into ar120gir_periods(period_name)
3156: select
3157: distinct period_name
3158: from gl_periods p
3159: where start_date >= (select min(start_date) from XLA_UPGRADE_DATES)
3160: and end_date <= (select max(end_date) from XLA_UPGRADE_DATES);
3161: EXCEPTION
3162: WHEN NO_DATA_FOUND THEN
3163: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3164: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');
3165: RAISE;
3166:
3167: WHEN OTHERS THEN
3168: -- arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3165: RAISE;
3166:
3167: WHEN OTHERS THEN
3168: -- arp_standard.debug('OTHERS EXCEPTION: ARP_XLA_UPGRADE.update_gl_sla_link');
3169: -- arp_standard.debug('NO_DATA_FOUND EXCEPTION: Insert into ar120gir_periods');
3170: RAISE;
3171: END;
3172:
3173:
3202: XLA_DISTRIBUTION_LINKS LNK,
3203: XLA_AE_LINES LN
3204: WHERE EXISTS
3205: (select /*+ PUSH_SUBQ */ null
3206: from ar120gir_periods periods
3207: where periods.period_name = GHD.period_name
3208: )
3209: AND GIMP.JE_HEADER_ID = GHD.JE_HEADER_ID
3210: AND GHD.JE_SOURCE = 'Receivables'