DBA Data[Home] [Help]

APPS.AP_CANCEL_PKG dependencies on AP_PRODUCT_REGISTRATIONS

Line 601: AP_Product_Registrations APR

597:
598: CURSOR c_reg_products IS
599: SELECT Reg_Application_ID
600: FROM AP_Invoices_All AI,
601: AP_Product_Registrations APR
602: WHERE AI.Invoice_ID = P_Invoice_ID
603: AND AI.Application_ID = APR.Reg_Application_ID
604: AND APR.Registration_Event_Type = 'INVOICE_CANCELLED';
605:

Line 1659: FROM AP_Product_Registrations

1655:
1656: CURSOR c_products_registered IS
1657: SELECT Reg_Application_ID,
1658: Registration_API
1659: FROM AP_Product_Registrations
1660: WHERE Reg_Application_ID = P_Application_ID
1661: AND Registration_Event_Type = P_Event_Type;
1662:
1663: BEGIN