APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on WIP_CONSTANTS

Line 174: AND process_status <> wip_constants.completed

170: SELECT COUNT(*)
171: INTO l_tcount
172: FROM wsm_split_merge_txn_interface
173: WHERE organization_id = p_org_id
174: AND process_status <> wip_constants.completed
175: AND transaction_date <= l_sched_close_date;
176:
177: x_pending_wsm := l_tcount;
178:

Line 186: AND status <> wip_constants.completed

182: SELECT COUNT(*)
183: INTO l_tcount
184: FROM wsm_lot_move_txn_interface
185: WHERE organization_id = p_org_id
186: AND status <> wip_constants.completed
187: AND transaction_date <= l_sched_close_date;
188:
189: x_pending_wsm := x_pending_wsm + l_tcount;
190:

Line 198: AND process_status <> wip_constants.completed

194: SELECT COUNT(*)
195: INTO l_tcount
196: FROM wsm_lot_split_merges_interface
197: WHERE organization_id = p_org_id
198: AND process_status <> wip_constants.completed
199: AND transaction_date <= l_sched_close_date;
200:
201: x_pending_wsm := x_pending_wsm + l_tcount;
202:

Line 1112: AND costed <> wip_constants.completed

1108: SELECT COUNT(*)
1109: INTO l_count
1110: FROM wsm_split_merge_transactions
1111: WHERE organization_id = p_org_id
1112: AND costed <> wip_constants.completed
1113: AND transaction_date < l_sched_close_date
1114: AND rownum = 1;
1115:
1116: IF l_count <> 0 THEN

Line 1126: AND process_status <> wip_constants.completed

1122: SELECT COUNT(*)
1123: INTO l_count
1124: FROM wsm_split_merge_txn_interface
1125: WHERE organization_id = p_org_id
1126: AND process_status <> wip_constants.completed
1127: AND transaction_date < l_sched_close_date
1128: AND rownum = 1;
1129:
1130: IF l_count <> 0 THEN