APPS.IGR_GEN_001 dependencies on IGR_I_STATUS_V

Line 93: v_complete_status igr_i_status_v.enquiry_status%TYPE;

89: cst_both CONSTANT VARCHAR2(5) := 'BOTH';
90: v_person_id igr_i_appl_all.person_id%TYPE;
91: v_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE;
92: v_process_ind igr_i_appl_all.override_process_ind%TYPE;
93: v_complete_status igr_i_status_v.enquiry_status%TYPE;
94: v_acknowledge_status igr_i_status_v.enquiry_status%TYPE;
95: v_group_id igs_pe_persid_group.group_id%TYPE;
96: v_person_id_group_created VARCHAR2(1);
97: v_process_dt DATE;

Line 94: v_acknowledge_status igr_i_status_v.enquiry_status%TYPE;

90: v_person_id igr_i_appl_all.person_id%TYPE;
91: v_enquiry_appl_number igr_i_appl_all.enquiry_appl_number%TYPE;
92: v_process_ind igr_i_appl_all.override_process_ind%TYPE;
93: v_complete_status igr_i_status_v.enquiry_status%TYPE;
94: v_acknowledge_status igr_i_status_v.enquiry_status%TYPE;
95: v_group_id igs_pe_persid_group.group_id%TYPE;
96: v_person_id_group_created VARCHAR2(1);
97: v_process_dt DATE;
98: v_enquiries_processed NUMBER DEFAULT 0;

Line 114: FROM igr_i_status_v es

110:
111: -- Modified the following cursor as part of build of CRM recruitment changes. Bug: 2664699
112: CURSOR c_es (cp_enquiry_status as_statuses_vl.status_code%TYPE) IS
113: SELECT es.enquiry_status
114: FROM igr_i_status_v es
115: WHERE es.s_enquiry_status = cp_enquiry_status AND
116: es.enabled_flag = 'Y';
117:
118: --Changed the Cursor to check the Enquiry_date between low and high date AND Enquiry source type

Line 124: igr_i_status_v es

120: --changes. Bug: 2664699
121: CURSOR c_eap_es (cp_s_enquiry_status as_statuses_vl.status_code%TYPE) IS
122: SELECT eap.*
123: FROM igr_i_appl eap,
124: igr_i_status_v es
125: WHERE ((eap.enquiry_dt >= p_enquiry_dt_low OR p_enquiry_dt_low IS NULL) AND
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