APPS.IGR_GEN_001 dependencies on AS_STATUSES_VL

Line 112: CURSOR c_es (cp_enquiry_status as_statuses_vl.status_code%TYPE) IS

108:
109: v_group_cd igs_pe_persid_group_all.group_cd%TYPE;
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';

Line 121: CURSOR c_eap_es (cp_s_enquiry_status as_statuses_vl.status_code%TYPE) IS

117:
118: --Changed the Cursor to check the Enquiry_date between low and high date AND Enquiry source type
119: --and Enquiry Entry status passed are valid for the Persons. Modified the following cursor as part of CRM recruitment
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