DBA Data[Home] [Help]

APPS.JA_AU_COSTPROC_PKG dependencies on RCV_TRANSACTIONS

Line 36: /* Retrieve requisition_line_id from table RCV_TRANSACTIONS */

32:
33: END IF;
34: --
35:
36: /* Retrieve requisition_line_id from table RCV_TRANSACTIONS */
37:
38: begin
39: SELECT nvl(requisition_line_id,0)
40: INTO l_req_line_id

Line 41: FROM rcv_transactions

37:
38: begin
39: SELECT nvl(requisition_line_id,0)
40: INTO l_req_line_id
41: FROM rcv_transactions
42: WHERE inv_transaction_id = x_transaction_id
43: AND transaction_type = 'RECEIVE'
44: AND organization_id = x_org_id;
45: