DBA Data[Home] [Help]

APPS.PJM_TRANSFER_CHARGES_PKG dependencies on RCV_SHIPMENT_HEADERS

Line 294: l_Receipt_Num RCV_Shipment_Headers.Receipt_Num%TYPE;

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

Line 837: FROM rcv_shipment_headers rsh

833: if ( InvRec.RCV_Transaction_Id is not null ) then
834:
835: SELECT rsh.receipt_num
836: INTO l_receipt_num
837: FROM rcv_shipment_headers rsh
838: , rcv_transactions rt
839: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
840: AND rsh.shipment_header_id = rt.shipment_header_id;
841:

Line 1271: FROM rcv_shipment_headers rsh

1267: if ( InvRec.RCV_Transaction_Id is not null ) then
1268:
1269: SELECT rsh.receipt_num
1270: INTO l_receipt_num
1271: FROM rcv_shipment_headers rsh
1272: , rcv_transactions rt
1273: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1274: AND rsh.shipment_header_id = rt.shipment_header_id;
1275:

Line 1710: FROM rcv_shipment_headers rsh

1706: if ( InvRec.RCV_Transaction_Id is not null ) then
1707:
1708: SELECT rsh.receipt_num
1709: INTO l_receipt_num
1710: FROM rcv_shipment_headers rsh
1711: , rcv_transactions rt
1712: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
1713: AND rsh.shipment_header_id = rt.shipment_header_id;
1714:

Line 2138: FROM rcv_shipment_headers rsh

2134: if ( InvRec.RCV_Transaction_Id is not null ) then
2135:
2136: SELECT rsh.receipt_num
2137: INTO l_receipt_num
2138: FROM rcv_shipment_headers rsh
2139: , rcv_transactions rt
2140: WHERE rt.transaction_id = InvRec.RCV_Transaction_Id
2141: AND rsh.shipment_header_id = rt.shipment_header_id;
2142: