128: l_Freight_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
129: l_Tax_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
130: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
131: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
132: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;
133: l_User_Conv_Type GL_Daily_Conversion_Types.User_Conversion_Type%TYPE;
134: l_Start_Date DATE;
135: l_End_Date DATE;
136: l_Task_Id NUMBER;
728: if ( InvRec.RCV_Transaction_Id is not null ) then
729:
730: SELECT rsh.receipt_num
731: INTO l_receipt_num
732: FROM rcv_shipment_headers rsh
733: , rcv_transactions rt
734: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
735: AND rsh.shipment_header_id = rt.shipment_header_id;
736:
1020: if ( InvRec.RCV_Transaction_Id is not null ) then
1021:
1022: SELECT rsh.receipt_num
1023: INTO l_receipt_num
1024: FROM rcv_shipment_headers rsh
1025: , rcv_transactions rt
1026: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1027: AND rsh.shipment_header_id = rt.shipment_header_id;
1028: