DBA Data[Home] [Help]

APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on WIP_COST_TXN_INTERFACE

Line 139: FROM wip_cost_txn_interface

135: -- Pending WIP costing transactions (must resolve)
136: BEGIN
137: SELECT COUNT(*)
138: INTO l_tcount
139: FROM wip_cost_txn_interface
140: WHERE organization_id = p_org_id
141: AND transaction_date <= l_sched_close_date;
142:
143: x_pend_wip_cost := l_tcount;

Line 1097: FROM wip_cost_txn_interface

1093:
1094: l_stmt_num := 110;
1095: SELECT COUNT(*)
1096: INTO l_count
1097: FROM wip_cost_txn_interface
1098: WHERE organization_id = p_org_id
1099: AND transaction_date < l_sched_close_date
1100: AND rownum = 1;
1101:

Line 1103: l_unprocessed_table := 'WIP_COST_TXN_INTERFACE';

1099: AND transaction_date < l_sched_close_date
1100: AND rownum = 1;
1101:
1102: IF l_count <> 0 THEN
1103: l_unprocessed_table := 'WIP_COST_TXN_INTERFACE';
1104: RAISE UNPROCESSED_TXNS_EXIST;
1105: END IF;
1106:
1107: l_stmt_num := 120;