APPS.IGS_PERSONSTATS_PUB dependencies on HZ_PARTIES

Line 86: CURSOR c_group_id(p_person_id hz_parties.party_id%TYPE,p_group_id igs_pe_persid_group.group_id%TYPE) IS

82: WHERE group_id = p_group_id
83: AND NVL(TRUNC(start_date),TRUNC(SYSDATE)) <= TRUNC(SYSDATE)
84: AND NVL(TRUNC(end_date),TRUNC(SYSDATE)) >= TRUNC(SYSDATE);
85:
86: CURSOR c_group_id(p_person_id hz_parties.party_id%TYPE,p_group_id igs_pe_persid_group.group_id%TYPE) IS
87: SELECT 'X'
88: FROM igs_pe_prsid_grp_mem
89: WHERE person_id = p_person_id
90: AND group_id = p_group_id