DBA Data[Home] [Help]

APPS.PJM_TRANSFER_SPEC_CHARGES_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 132: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;

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;

Line 732: FROM rcv_shipment_headers rsh

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:

Line 1024: FROM rcv_shipment_headers rsh

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: