DBA Data[Home] [Help]

APPS.IGR_IMP_004 dependencies on IGR_I_PKGITM_ASSIGN

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