DBA Data[Home] [Help]

APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on WSM_SPLIT_MERGE_TXN_INTERFACE

Line 172: FROM wsm_split_merge_txn_interface

168: -- Pending Split Merge Transactions interface
169:
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:

Line 1124: FROM wsm_split_merge_txn_interface

1120:
1121: l_stmt_num := 130;
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;

Line 1131: l_unprocessed_table := 'WSM_SPLIT_MERGE_TXN_INTERFACE';

1127: AND transaction_date < l_sched_close_date
1128: AND rownum = 1;
1129:
1130: IF l_count <> 0 THEN
1131: l_unprocessed_table := 'WSM_SPLIT_MERGE_TXN_INTERFACE';
1132: RAISE UNPROCESSED_TXNS_EXIST;
1133: END IF;
1134:
1135: l_stmt_num := 140;