APPS.IGR_GEN_001 dependencies on IGS_PE_PERSID_GROUP_ALL

Line 109: v_group_cd igs_pe_persid_group_all.group_cd%TYPE;

105: l_msg_count NUMBER;
106: l_s_enq_stat igr_i_appl_v.s_enquiry_status%TYPE;
107: PRAGMA EXCEPTION_INIT (e_resource_busy, -54);
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

Line 246: CURSOR c_get_group_cd(cp_group_id IGS_PE_PERSID_GROUP_ALL.GROUP_ID%TYPE) IS

242: (epi.actual_avail_to_date >= SYSDATE) AND
243: NVL(eapmpi.donot_mail_ind,'N') = 'N';
244:
245: --Cursor to get the group code of the Person ID Group for a given group id (rghosh, bug#3973942: APC Integration Build)
246: CURSOR c_get_group_cd(cp_group_id IGS_PE_PERSID_GROUP_ALL.GROUP_ID%TYPE) IS
247: SELECT group_cd
248: FROM igs_pe_persid_group_all
249: WHERE group_id = cp_group_id;
250:

Line 248: FROM igs_pe_persid_group_all

244:
245: --Cursor to get the group code of the Person ID Group for a given group id (rghosh, bug#3973942: APC Integration Build)
246: CURSOR c_get_group_cd(cp_group_id IGS_PE_PERSID_GROUP_ALL.GROUP_ID%TYPE) IS
247: SELECT group_cd
248: FROM igs_pe_persid_group_all
249: WHERE group_id = cp_group_id;
250:
251:
252: /** IDOPA2 New cursors added to take care of package items if p_inq_info_type is not null **/