APPS.CST_SLA_UPDATE_PKG dependencies on WIP_TRANSACTIONS

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

1620: X_Argument10 in varchar2 default null)
1621: IS
1622:
1623: l_product varchar2(30);
1624: l_table_name varchar2(30) := 'WIP_TRANSACTIONS';
1625: l_id_column varchar2(30) := 'TRANSACTION_ID';
1626:
1627: l_update_name varchar2(30);
1628:

Line 2958: wip_transactions wt

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

Line 3374: wip_transactions wt,

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,
3377: HR_ORGANIZATION_INFORMATION HOI2,
3378: gl_ledgers sob,