DBA Data[Home] [Help]

APPS.PJM_TRANSFER_CHARGES_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 293: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;

289: l_Tax_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
290: l_Misc_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
291: l_Exp_Comment PA_Transaction_Interface_All.Expenditure_Comment%TYPE;
292: l_Batch_Name PA_Transaction_Interface_All.Batch_Name%TYPE;
293: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;
294: l_User_Conv_Type GL_Daily_Conversion_Types.User_Conversion_Type%TYPE;
295: l_Start_Date DATE;
296: l_End_Date DATE;
297: l_Task_Id NUMBER;

Line 765: FROM rcv_shipment_headers rsh

761: if ( InvRec.RCV_Transaction_Id is not null ) then
762:
763: SELECT rsh.receipt_num
764: INTO l_receipt_num
765: FROM rcv_shipment_headers rsh
766: , rcv_transactions rt
767: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
768: AND rsh.shipment_header_id = rt.shipment_header_id;
769:

Line 1133: FROM rcv_shipment_headers rsh

1129: if ( InvRec.RCV_Transaction_Id is not null ) then
1130:
1131: SELECT rsh.receipt_num
1132: INTO l_receipt_num
1133: FROM rcv_shipment_headers rsh
1134: , rcv_transactions rt
1135: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1136: AND rsh.shipment_header_id = rt.shipment_header_id;
1137:

Line 1508: FROM rcv_shipment_headers rsh

1504: if ( InvRec.RCV_Transaction_Id is not null ) then
1505:
1506: SELECT rsh.receipt_num
1507: INTO l_receipt_num
1508: FROM rcv_shipment_headers rsh
1509: , rcv_transactions rt
1510: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1511: AND rsh.shipment_header_id = rt.shipment_header_id;
1512:

Line 1873: FROM rcv_shipment_headers rsh

1869: if ( InvRec.RCV_Transaction_Id is not null ) then
1870:
1871: SELECT rsh.receipt_num
1872: INTO l_receipt_num
1873: FROM rcv_shipment_headers rsh
1874: , rcv_transactions rt
1875: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1876: AND rsh.shipment_header_id = rt.shipment_header_id;
1877: