APPS.CST_SLA_UPDATE_PKG dependencies on CST_XLA_SEQ_GT

Line 2112: /*execute immediate 'CREATE GLOBAL TEMPORARY TABLE cst_xla_seq_gt(

2108: END IF;
2109:
2110: l_je_category_name := 'MTL';
2111:
2112: /*execute immediate 'CREATE GLOBAL TEMPORARY TABLE cst_xla_seq_gt(
2113: source_id_int_1 NUMBER,
2114: source_id_int_2 number,
2115: source_id_int_3 number,
2116: source_id_int_4 number,

Line 2131: insert into cst_xla_seq_gt (

2127: /* one mta line -> one xla_ae_line -> one xla_distribution_link */
2128:
2129: l_stmt_num :=10;
2130:
2131: insert into cst_xla_seq_gt (
2132: source_id_int_1,
2133: source_id_int_2,
2134: source_id_int_3,
2135: entity_id,

Line 2226: from cst_xla_seq_gt cxs)

2222: (select /*+ unnest */
2223: source_id_int_1,
2224: source_id_int_2,
2225: source_id_int_3
2226: from cst_xla_seq_gt cxs)
2227: and mta.encumbrance_type_id is null;
2228:
2229: l_stmt_num :=30;
2230:

Line 2668: cst_xla_seq_gt cxs

2664: hr_organization_information hoi2,
2665: gl_ledgers sob,
2666: org_acct_periods oap,
2667: org_gl_batches ogb,
2668: cst_xla_seq_gt cxs
2669: where mta.transaction_id = cxs.source_id_int_1
2670: and mta.organization_id = cxs.source_id_int_2
2671: and nvl(mta.transaction_source_type_id, -1) = nvl(cxs.source_id_int_3, -1)
2672: and mta.encumbrance_type_id is null

Line 2937: insert into cst_xla_seq_gt(

2933: /* one wta line -> one xla_ae_line -> one xla_distribution_link */
2934:
2935: l_stmt_num :=10;
2936:
2937: insert into cst_xla_seq_gt(
2938: source_id_int_1,
2939: source_id_int_2,
2940: source_id_int_3,
2941: entity_id,

Line 3006: from cst_xla_seq_gt cxs);

3002: where (wta.transaction_id, nvl(wta.resource_id,-6661), nvl(wta.basis_type,-6661)) in
3003: (select source_id_int_1,
3004: nvl(source_id_int_2,-6661),
3005: nvl(source_id_int_3,-6661)
3006: from cst_xla_seq_gt cxs);
3007:
3008:
3009: l_stmt_num :=30;
3010:

Line 3381: cst_xla_seq_gt cxs

3377: HR_ORGANIZATION_INFORMATION HOI2,
3378: gl_ledgers sob,
3379: ORG_ACCT_PERIODS oap,
3380: org_gl_batches ogb,
3381: cst_xla_seq_gt cxs
3382: where wta.transaction_id=cxs.source_id_int_1
3383: and wt.transaction_id=cxs.source_id_int_1
3384: and nvl(wta.resource_id,-6661)=nvl(cxs.source_id_int_2,-6661)
3385: and nvl(wta.basis_type,-6661)=nvl(cxs.source_id_int_3,-6661)

Line 3520: insert into cst_xla_seq_gt(

3516: */
3517:
3518: l_stmt_num :=10;
3519:
3520: insert into cst_xla_seq_gt(
3521: source_id_int_1,
3522: source_id_int_2,
3523: source_id_int_3,
3524: source_id_int_4,

Line 3596: where rrs.rcv_transaction_id in (select source_id_int_1 from cst_xla_seq_gt cxs)

3592: rcv_sub_ledger_id = nvl(rcv_sub_ledger_id, rcv_receiving_sub_ledger_s.nextval),
3593: last_update_date = gUpdateDate,
3594: last_updated_by = gUserId,
3595: last_update_login = gLoginId
3596: where rrs.rcv_transaction_id in (select source_id_int_1 from cst_xla_seq_gt cxs)
3597: and rrs.ENCUMBRANCE_TYPE_ID is null;
3598:
3599:
3600: l_stmt_num :=30;

Line 3923: cst_xla_seq_gt cxs

3919: cem.event_class_code event_class_code
3920: from rcv_receiving_sub_ledger rrs,
3921: cst_xla_rcv_event_map cem,
3922: GL_CODE_COMBINATIONS gcc,
3923: cst_xla_seq_gt cxs
3924: where rrs.rcv_transaction_id = cxs.source_id_int_1
3925: and nvl(rrs.accounting_event_id,-1) = nvl(cxs.source_id_int_2,-1) /*Bug 12538372*/
3926: and rrs.ENCUMBRANCE_TYPE_ID is null
3927: and cxs.source_id_int_4 = cem.transaction_type_id