APPS.IGR_GEN_001 dependencies on IGR_I_PKG_ITEMS_V

Line 147: igr_i_pkg_items_v epi

143: CURSOR c_eapmpi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
144: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
145: SELECT 'X'
146: FROM igr_i_a_pkgitm eapmpi,
147: igr_i_pkg_items_v epi
148: WHERE eapmpi.person_id = cp_person_id AND
149: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
150: eapmpi.mailed_dt IS NULL AND
151: eapmpi.package_item_id = epi.package_item_id ;

Line 160: igr_i_pkg_items_v epi

156: CURSOR c_eapmpi_epi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
157: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
158: SELECT 'X'
159: FROM igr_i_a_pkgitm eapmpi,
160: igr_i_pkg_items_v epi
161: WHERE eapmpi.person_id = cp_person_id AND
162: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
163: eapmpi.mailed_dt IS NULL AND
164: eapmpi.package_item_id = epi.package_item_id AND

Line 174: igr_i_pkg_items_v epi

170: CURSOR c_eapmpi_get_epi ( cp_person_id igr_i_a_pkgitm.person_id%TYPE,
171: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
172: SELECT 'X'
173: FROM igr_i_a_pkgitm eapmpi,
174: igr_i_pkg_items_v epi
175: WHERE eapmpi.person_id = cp_person_id AND
176: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
177: eapmpi.mailed_dt IS NULL AND
178: eapmpi.package_item_id = epi.package_item_id AND

Line 192: igr_i_pkg_items_v epi --Setup (joined with CRM setup to hold all the attributes of Packge Items)

188: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
189: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
190: SELECT 'X'
191: FROM igr_i_a_pkgitm eapmpi, --Transaction table holding Package items of the inquiry instance
192: igr_i_pkg_items_v epi --Setup (joined with CRM setup to hold all the attributes of Packge Items)
193: WHERE eapmpi.person_id = cp_person_id AND
194: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
195: eapmpi.mailed_dt IS NULL AND
196: eapmpi.package_item_id = epi.package_item_id AND

Line 206: igr_i_pkg_items_v epi

202: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
203: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
204: SELECT 'X'
205: FROM igr_i_a_pkgitm eapmpi, --Transaction table (Inquiry Instance table holding Package items)
206: igr_i_pkg_items_v epi
207: WHERE eapmpi.person_id = cp_person_id AND
208: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
209: eapmpi.mailed_dt IS NULL AND
210: eapmpi.package_item_id = epi.package_item_id AND

Line 222: igr_i_pkg_items_v epi

218: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
219: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
220: SELECT 'X'
221: FROM igr_i_a_pkgitm eapmpi,
222: igr_i_pkg_items_v epi
223: WHERE eapmpi.person_id = cp_person_id AND
224: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
225: eapmpi.mailed_dt IS NULL AND
226: eapmpi.package_item_id = epi.package_item_id AND

Line 236: igr_i_pkg_items_v epi

232: cp_person_id igr_i_a_pkgitm.person_id%TYPE,
233: cp_enquiry_appl_number igr_i_a_pkgitm.enquiry_appl_number%TYPE) IS
234: SELECT 'X'
235: FROM igr_i_a_pkgitm eapmpi,
236: igr_i_pkg_items_v epi
237: WHERE eapmpi.person_id = cp_person_id AND
238: eapmpi.enquiry_appl_number = cp_enquiry_appl_number AND
239: eapmpi.mailed_dt IS NULL AND
240: eapmpi.package_item_id = epi.package_item_id AND

Line 276: igr_i_pkg_items_v epi -- Package Items setup view

272: -- Modified the following cursor as part of build of CRM recruitment changes. Bug: 2664699
273: CURSOR c_eapmpi_epi IS
274: SELECT eapmpi.ROWID, eapmpi.*
275: FROM igr_i_a_pkgitm eapmpi,
276: igr_i_pkg_items_v epi -- Package Items setup view
277: WHERE eapmpi.person_id = p_person_id AND
278: eapmpi.enquiry_appl_number = p_enquiry_appl_number AND
279: eapmpi.mailed_dt IS NULL AND
280: eapmpi.package_item_id = epi.package_item_id AND