APPS.CST_PERIODSUMMARY_PVT dependencies on WIP_CONSTANTS

Line 138: AND costed <> wip_constants.completed

134: SELECT COUNT(*)
135: INTO l_count
136: FROM wsm_split_merge_transactions
137: WHERE organization_id = p_org_id
138: AND costed <> wip_constants.completed
139: AND transaction_date < l_sched_close_date;
140:
141: IF l_count <> 0 THEN
142: l_unprocessed_table := 'WSM_SPLIT_MERGE_TRANSACTIONS';

Line 150: AND process_status <> wip_constants.completed

146: SELECT COUNT(*)
147: INTO l_count
148: FROM wsm_split_merge_txn_interface
149: WHERE organization_id = p_org_id
150: AND process_status <> wip_constants.completed
151: AND transaction_date < l_sched_close_date;
152:
153: IF l_count <> 0 THEN
154: l_unprocessed_table := 'WSM_SPLIT_MERGE_TXN_INTERFACE';