DBA Data[Home] [Help]

APPS.PJM_TRANSFER_IPV_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 192: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;

188:
189: l_IPV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
190: l_ERV_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
191: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
192: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;
193: l_User_Conv_Type GL_Daily_Conversion_Types.User_Conversion_Type%TYPE;
194: l_Start_Date DATE;
195: l_End_Date DATE;
196: l_Task_Id NUMBER;

Line 487: FROM rcv_shipment_headers rsh

483: if ( InvRec.RCV_Transaction_Id is not null ) then
484:
485: SELECT rsh.receipt_num
486: INTO l_receipt_num
487: FROM rcv_shipment_headers rsh
488: , rcv_transactions rt
489: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
490: AND rsh.shipment_header_id = rt.shipment_header_id;
491: