APPS.IGR_IMP_004 dependencies on IGR_I_APPL_INT

Line 663: cp_inquiry_type_id igr_i_appl_int.inquiry_type_id%TYPE,

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,
667: AMS_P_DELIVERABLES_V DELIV

Line 664: cp_package_reduct_ind igr_i_appl_int.pkg_reduct_ind%TYPE) IS

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,
667: AMS_P_DELIVERABLES_V DELIV
668: WHERE pkgitm.package_item_id = p_inq_pkg_rec.package_item_id

Line 703: --Cursor to get the inquiry_type_id and package_reduct_ind from IGR_I_APPL_INT table.

699: )
700: )
701: );
702:
703: --Cursor to get the inquiry_type_id and package_reduct_ind from IGR_I_APPL_INT table.
704: CURSOR c_appl_int (cp_interface_inq_appl_id igr_i_pkg_int.interface_inq_appl_id%TYPE) IS
705: SELECT inquiry_type_id, pkg_reduct_ind
706: FROM igr_i_appl_int
707: WHERE interface_inq_appl_id = cp_interface_inq_appl_id;

Line 706: FROM igr_i_appl_int

702:
703: --Cursor to get the inquiry_type_id and package_reduct_ind from IGR_I_APPL_INT table.
704: CURSOR c_appl_int (cp_interface_inq_appl_id igr_i_pkg_int.interface_inq_appl_id%TYPE) IS
705: SELECT inquiry_type_id, pkg_reduct_ind
706: FROM igr_i_appl_int
707: WHERE interface_inq_appl_id = cp_interface_inq_appl_id;
708:
709: l_appl_int_rec c_appl_int%ROWTYPE;
710: