APPS.CST_SLA_UPDATE_PKG dependencies on XLA_UPGRADE_DATES

Line 771: from xla_upgrade_dates xud

767: Begin
768:
769: select TO_CHAR(MIN(xud.start_date), 'YYYYDDMM'), TO_CHAR(MAX(xud.end_date), 'YYYYDDMM')
770: into l_argument4, l_argument5
771: from xla_upgrade_dates xud
772: where ledger_id = nvl(X_Ledger_Id,ledger_id);
773:
774: l_stmt_num :=20;
775: if (l_argument4 is not null) then

Line 1010: from xla_upgrade_dates xud

1006: begin
1007:
1008: select TO_CHAR(MIN(xud.start_date), 'YYYYDDMM'), TO_CHAR(MAX(xud.end_date), 'YYYYDDMM')
1009: into l_argument4, l_argument5
1010: from xla_upgrade_dates xud
1011: where ledger_id = nvl(X_Ledger_Id,ledger_id);
1012:
1013: l_stmt_num :=20;
1014: if (l_argument4 is not null) then

Line 1248: from xla_upgrade_dates xud

1244: begin
1245:
1246: select TO_CHAR(MIN(xud.start_date), 'YYYYDDMM'), TO_CHAR(MAX(xud.end_date), 'YYYYDDMM')
1247: into l_argument4, l_argument5
1248: from xla_upgrade_dates xud
1249: where ledger_id = nvl(X_Ledger_Id,ledger_id);
1250:
1251: l_stmt_num :=20;
1252: if (l_argument4 is not null) then

Line 2149: xla_upgrade_dates xud,

2145: select /*+ leading(mmt,oap) use_hash(xud, oap) swap_join_inputs(oap) index(mmt, mtl_material_transactions_u1) */
2146: distinct
2147: mta.transaction_id, mta.organization_id, mta.transaction_source_type_id
2148: from mtl_transaction_accounts mta,
2149: xla_upgrade_dates xud,
2150: hr_organization_information hoi2,
2151: org_acct_periods oap,
2152: mtl_material_transactions mmt
2153: where mmt.transaction_id >= X_min_id

Line 2955: from xla_upgrade_dates xud,

2951: from wip_transaction_accounts wta
2952: where wta.transaction_id >= X_min_id
2953: and wta.transaction_id <= X_max_id
2954: and exists (select null
2955: from xla_upgrade_dates xud,
2956: HR_ORGANIZATION_INFORMATION HOI2,
2957: ORG_ACCT_PERIODS oap,
2958: wip_transactions wt
2959: where HOI2.organization_id = oap.organization_id

Line 3551: from xla_upgrade_dates xud,

3547: gl_ledgers sob,
3548: (select /*+ no_merge leading(rrs) use_hash(xud) swap_join_inputs(xud) */
3549: distinct rcv_transaction_id,
3550: accounting_event_id
3551: from xla_upgrade_dates xud,
3552: rcv_receiving_sub_ledger rrs
3553: where rrs.rcv_transaction_id between x_min_id and x_max_id
3554: and xud.ledger_id = rrs.set_of_books_id
3555: and rrs.accounting_date between xud.start_date and xud.end_date