APPS.CST_XLA_PVT dependencies on RCV_TRANSACTIONS

Line 286: l_parent_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;

282: l_bc_event_id NUMBER;
283: l_event_type_code CST_XLA_RCV_EVENT_MAP.EVENT_TYPE_CODE%TYPE;
284: l_event_type_id RCV_ACCOUNTING_EVENTS.EVENT_TYPE_ID%TYPE;
285:
286: l_parent_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
287: l_parent_rcv_txn_id NUMBER;
288: /*l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;*/
289:
290:

Line 542: FROM RCV_TRANSACTIONS

538: ELSE /* Correction to Deliver or Return */
539: l_stmt_num := 47;
540: SELECT nvl(PARENT_TRANSACTION_ID, -1)
541: INTO l_parent_rcv_txn_id
542: FROM RCV_TRANSACTIONS
543: WHERE transaction_id = p_trx_info.TRANSACTION_ID;
544: l_stmt_num := 48;
545: IF (l_parent_rcv_txn_id <> -1) THEN
546: SELECT TRANSACTION_TYPE

Line 548: FROM RCV_TRANSACTIONS

544: l_stmt_num := 48;
545: IF (l_parent_rcv_txn_id <> -1) THEN
546: SELECT TRANSACTION_TYPE
547: INTO l_parent_txn_type
548: FROM RCV_TRANSACTIONS
549: WHERE transaction_id = l_parent_rcv_txn_id;
550: END IF;
551: l_stmt_num := 49;
552: SELECT event_type_code

Line 843: FROM rcv_transactions rt

839: AND MMT.TRANSACTION_ACTION_ID = 26
840: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 1
841: AND NVL(MMT.LOGICAL_TRX_TYPE_CODE,5) = 2
842: AND EXISTS ( SELECT 'X'
843: FROM rcv_transactions rt
844: WHERE rt.transaction_id =
845: mmt.rcv_transaction_id
846: AND rt.organization_id =
847: p_trx_info.txn_organization_id