APPS.IGS_HE_EXTRACT_PKG dependencies on IGS_PE_PERSID_GROUP

Line 313: FROM igs_pe_persid_group a ,

309: p_group_cd VARCHAR2,
310: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
311: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
312: SELECT a.group_cd
313: FROM igs_pe_persid_group a ,
314: igs_pe_prsid_grp_mem_all b
315: WHERE b.person_id = p_person_id
316: AND a.group_cd = p_group_cd
317: AND ( b.Start_Date IS NULL OR b.Start_Date <= cp_enrl_end_dt)

Line 324: FROM igs_pe_persid_group_v

320:
321: -- Determine type (static or dynamic) of persion id group
322: CURSOR c_group_type (p_group_cd VARCHAR2) IS
323: SELECT group_id, group_type
324: FROM igs_pe_persid_group_v
325: WHERE group_cd = p_group_cd;
326:
327: l_person_id NUMBER;
328: l_group_id NUMBER;

Line 329: l_group_type igs_pe_persid_group_v.group_type%TYPE;

325: WHERE group_cd = p_group_cd;
326:
327: l_person_id NUMBER;
328: l_group_id NUMBER;
329: l_group_type igs_pe_persid_group_v.group_type%TYPE;
330: l_psn_group_cd igs_pe_persid_group.group_cd%TYPE := NULL;
331:
332: BEGIN
333:

Line 330: l_psn_group_cd igs_pe_persid_group.group_cd%TYPE := NULL;

326:
327: l_person_id NUMBER;
328: l_group_id NUMBER;
329: l_group_type igs_pe_persid_group_v.group_type%TYPE;
330: l_psn_group_cd igs_pe_persid_group.group_cd%TYPE := NULL;
331:
332: BEGIN
333:
334: FOR l_prm IN c_prm