APPS.CST_SLA_UPDATE_PKG dependencies on XLA_UPGRADE_DATES

Line 479: from xla_upgrade_dates xud;

475: Begin
476:
477: select TO_CHAR(MIN(xud.start_date), 'YYYYDDMM'), TO_CHAR(MAX(xud.end_date), 'YYYYDDMM')
478: into l_argument4, l_argument5
479: from xla_upgrade_dates xud;
480:
481: if (l_argument4 is not null) then
482: AD_CONC_UTILS_PKG.submit_subrequests(
483: X_errbuf=>X_errbuf,

Line 702: from xla_upgrade_dates xud;

698: begin
699:
700: select TO_CHAR(MIN(xud.start_date), 'YYYYDDMM'), TO_CHAR(MAX(xud.end_date), 'YYYYDDMM')
701: into l_argument4, l_argument5
702: from xla_upgrade_dates xud;
703:
704: if (l_argument4 is not null) then
705: AD_CONC_UTILS_PKG.submit_subrequests(
706: X_errbuf=>X_errbuf,

Line 924: from xla_upgrade_dates xud;

920: begin
921:
922: select TO_CHAR(MIN(xud.start_date), 'YYYYDDMM'), TO_CHAR(MAX(xud.end_date), 'YYYYDDMM')
923: into l_argument4, l_argument5
924: from xla_upgrade_dates xud;
925:
926: if (l_argument4 is not null) then
927: AD_CONC_UTILS_PKG.submit_subrequests(
928: X_errbuf=>X_errbuf,

Line 1893: xla_upgrade_dates xud,

1889: select /*+ leading(mmt,oap) use_hash(xud, oap) swap_join_inputs(oap) index(mmt, mtl_material_transactions_u1) */
1890: distinct
1891: mta.transaction_id, mta.organization_id, mta.transaction_source_type_id
1892: from mtl_transaction_accounts mta,
1893: xla_upgrade_dates xud,
1894: hr_organization_information hoi2,
1895: org_acct_periods oap,
1896: mtl_material_transactions mmt
1897: where mmt.transaction_id >= X_min_id

Line 2699: from xla_upgrade_dates xud,

2695: from wip_transaction_accounts wta
2696: where wta.transaction_id >= X_min_id
2697: and wta.transaction_id <= X_max_id
2698: and exists (select null
2699: from xla_upgrade_dates xud,
2700: HR_ORGANIZATION_INFORMATION HOI2,
2701: ORG_ACCT_PERIODS oap,
2702: wip_transactions wt
2703: where HOI2.organization_id = oap.organization_id

Line 3275: from xla_upgrade_dates xud,

3271: hr_organization_information hoi2,
3272: gl_ledgers sob,
3273: (select /*+ no_merge leading(rrs) use_hash(xud) swap_join_inputs(xud) */
3274: distinct rcv_transaction_id
3275: from xla_upgrade_dates xud,
3276: rcv_receiving_sub_ledger rrs
3277: where rrs.rcv_transaction_id between x_min_id and x_max_id
3278: and xud.ledger_id = rrs.set_of_books_id
3279: and rrs.accounting_date between xud.start_date and xud.end_date