APPS.CST_SLA_UPDATE_PKG dependencies on WIP_TRANSACTION_ACCOUNTS

Line 2951: from wip_transaction_accounts wta

2947: XLA_transaction_ENTITies_S.nextval,
2948: xla_events_s.nextval,
2949: xla_ae_headers_s.NEXTVAL
2950: from (select distinct wta.transaction_id, wta.resource_id, wta.basis_type
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,

Line 2997: wip_transaction_accounts wta

2993:
2994: l_stmt_num :=20;
2995:
2996: update /*+ leading(cxs) use_nl(wta) index(wta) */
2997: wip_transaction_accounts wta
2998: set wip_sub_ledger_id = cst_wip_sub_ledger_id_s.nextval,
2999: last_update_date = gUpdateDate,
3000: last_updated_by = gUserId,
3001: last_update_login = gLoginId

Line 3330: 'WIP_TRANSACTION_ACCOUNTS' src_dist_type,

3326: 'UNKNOWN') accounting_class_code,
3327: wta.gl_sl_link_id link_id,
3328: 'WTA' link_table,
3329: 'C' line_type_code,
3330: 'WIP_TRANSACTION_ACCOUNTS' src_dist_type,
3331: wta.wip_sub_ledger_id src_dist_id_num_1,
3332: 'N' merge_dup_code,
3333: /* Bug 11842928: Modified the Entered value calculation
3334: DECODE(sign(wta.base_transaction_value), 1, wta.base_transaction_value, 0, 0, NULL) ACCOUNTED_DR,

Line 3372: from wip_transaction_accounts wta,

3368: NVL(wta.TRANSACTION_VALUE,wta.BASE_TRANSACTION_VALUE) entered_amount,
3369: decode(sign(wta.base_transaction_value),0,'Y', 'N') ZERO_AMOUNT_FLAG,
3370: decode(gcc.reference3,'Y', 'P', null) CONTROL_BALANCE_FLAG,
3371: cem.event_class_code event_class_code
3372: from wip_transaction_accounts wta,
3373: cst_xla_wip_event_map cem,
3374: wip_transactions wt,
3375: GL_CODE_COMBINATIONS gcc,
3376: mtl_parameters mp,