APPS.CST_SLA_UPDATE_PKG dependencies on WIP_TRANSACTIONS

Line 1329: l_table_name varchar2(30) := 'WIP_TRANSACTIONS';

1325: IS
1326:
1327: l_worker_id number;
1328: l_product varchar2(30);
1329: l_table_name varchar2(30) := 'WIP_TRANSACTIONS';
1330: l_id_column varchar2(30) := 'TRANSACTION_ID';
1331:
1332: l_update_name varchar2(30);
1333:

Line 2702: wip_transactions wt

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
2704: and HOI2.ORG_INFORMATION_CONTEXT ='Accounting Information'
2705: AND HOI2.ORG_INFORMATION1 = TO_CHAR(xud.ledger_ID)
2706: and wt.acct_period_id = oap.acct_period_id

Line 3076: wip_transactions wt,

3072: decode(gcc.reference3,'Y', 'P', null) CONTROL_BALANCE_FLAG,
3073: cem.event_class_code event_class_code
3074: from wip_transaction_accounts wta,
3075: cst_xla_wip_event_map cem,
3076: wip_transactions wt,
3077: GL_CODE_COMBINATIONS gcc,
3078: mtl_parameters mp,
3079: HR_ORGANIZATION_INFORMATION HOI2,
3080: gl_ledgers sob,