APPS.IGR_IMP_004 dependencies on AS_SALES_LEAD_LINES

Line 662: CURSOR c_package_item(cp_sales_lead_id as_sales_lead_lines.sales_lead_id%TYPE,

658:
659: ------------------------Cursor declaration--------------------------------------
660: -- Cursor to validate the package items (This cursor is changed as a part of the SQL tuning
661: -- bug 4991561)
662: CURSOR c_package_item(cp_sales_lead_id as_sales_lead_lines.sales_lead_id%TYPE,
663: cp_inquiry_type_id igr_i_appl_int.inquiry_type_id%TYPE,
664: cp_package_reduct_ind igr_i_appl_int.pkg_reduct_ind%TYPE) IS
665: SELECT 'X'
666: FROM IGR_I_PKG_ITEM PKGITM,

Line 685: FROM as_sales_lead_lines

681: -- Don't Validate package items against Academic Interest Category when Package Reduction Indicator is not set('N' or NULL).
682: OR NVL(cp_package_reduct_ind,'N') = 'N'
683: -- Don't Validate package items when there are no Academic Interest Categories associated.
684: OR NOT EXISTS ( SELECT 1
685: FROM as_sales_lead_lines
686: WHERE sales_lead_id = cp_sales_lead_id
687: AND category_id IS NOT NULL
688: AND category_set_id IS NOT NULL
689: )

Line 693: FROM igr_i_pkgitm_assign pia, as_sales_lead_lines lines

689: )
690: -- Validate package items against Academic Interest Category when Package Reduction Indicator is set to 'Y'.
691: OR ( cp_package_reduct_ind = 'Y' AND
692: EXISTS ( SELECT 1
693: FROM igr_i_pkgitm_assign pia, as_sales_lead_lines lines
694: WHERE pia.package_item_id = pkgitm.package_item_id
695: AND pia.product_category_id = lines.category_id
696: AND pia.product_category_set_id = lines.category_set_id
697: AND lines.sales_lead_id = cp_sales_lead_id