APPS.IGR_GEN_001 dependencies on IGR_I_A_LINES_V

Line 130: (p_product_category_id IS NULL OR EXISTS (SELECT 'X' FROM igr_i_a_lines_v alin

126: (eap.enquiry_dt <= p_enquiry_dt_high OR p_enquiry_dt_high IS NULL)) AND
127: eap.enquiry_status = es.enquiry_status AND
128: es.s_enquiry_status = cp_s_enquiry_status AND
129: (eap.inquiry_method_code = p_inq_src_type OR p_inq_src_type IS NULL) AND
130: (p_product_category_id IS NULL OR EXISTS (SELECT 'X' FROM igr_i_a_lines_v alin
131: WHERE alin.person_id = eap.person_id AND
132: alin.enquiry_appl_number = eap.enquiry_appl_number AND
133: alin.product_category_id = p_product_category_id )) AND
134: (p_inq_info_type IS NULL OR EXISTS (SELECT 'X' FROM igr_i_a_itype ityp