DBA Data[Home] [Help]

APPS.CSTPPWCL dependencies on WIP_TRANSACTIONS

Line 59: FROM wip_transactions wt,

55: CURSOR c_jobclose_txn IS
56: SELECT NVL(MAX(wt.transaction_id),-1) txn_id,
57: wt.organization_id org_id,
58: wt.wip_entity_id entity_id
59: FROM wip_transactions wt,
60: wip_entities we
61: WHERE wt.transaction_date BETWEEN TRUNC(p_start_date)
62: AND (TRUNC(p_end_date) + 0.99999)
63: AND wt.transaction_type = 6 --Job Close