APPS.CST_XLA_PVT dependencies on RCV_TRANSACTIONS

Line 377: l_parent_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;

373: l_bc_event_id NUMBER;
374: l_event_type_code CST_XLA_RCV_EVENT_MAP.EVENT_TYPE_CODE%TYPE;
375: l_event_type_id RCV_ACCOUNTING_EVENTS.EVENT_TYPE_ID%TYPE;
376:
377: l_parent_txn_type RCV_TRANSACTIONS.TRANSACTION_TYPE%TYPE;
378: l_parent_rcv_txn_id NUMBER;
379: /*l_pjm_blueprint PJM_ORG_PARAMETERS.PA_POSTING_FLAG%TYPE;*/
380:
381:

Line 663: -- FROM RCV_TRANSACTIONS

659: /* Correction to Deliver or Return */
660: -- l_stmt_num := 47;
661: -- SELECT nvl(PARENT_TRANSACTION_ID, -1)
662: -- INTO l_parent_rcv_txn_id
663: -- FROM RCV_TRANSACTIONS
664: -- WHERE transaction_id = p_trx_info.TRANSACTION_ID;
665: -- l_stmt_num := 48;
666: -- IF (l_parent_rcv_txn_id <> -1) THEN
667: -- SELECT TRANSACTION_TYPE

Line 669: -- FROM RCV_TRANSACTIONS

665: -- l_stmt_num := 48;
666: -- IF (l_parent_rcv_txn_id <> -1) THEN
667: -- SELECT TRANSACTION_TYPE
668: -- INTO l_parent_txn_type
669: -- FROM RCV_TRANSACTIONS
670: -- WHERE transaction_id = l_parent_rcv_txn_id;
671: --END IF;
672: -- l_stmt_num := 49;
673: -- SELECT event_type_code

Line 975: FROM rcv_transactions rt

971: AND MMT.TRANSACTION_ACTION_ID = 26
972: AND MMT.TRANSACTION_SOURCE_TYPE_ID = 1
973: AND NVL(MMT.LOGICAL_TRX_TYPE_CODE,5) = 2
974: AND EXISTS ( SELECT 'X'
975: FROM rcv_transactions rt
976: WHERE rt.transaction_id =
977: mmt.rcv_transaction_id
978: AND rt.organization_id =
979: p_trx_info.txn_organization_id