APPS.IGS_PERSONSTATS_PUB dependencies on IGS_PE_PERSID_GROUP

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

Line 114: check_length('GROUP_ID', 'IGS_PE_PERSID_GROUP_ALL', length(TRUNC(p_group_id)));

110: -- Validate all the parameters for their length
111: -- PERSON_ID
112: check_length('PERSON_ID', 'IGS_AD_PS_APPL_INST_ALL', length(TRUNC(p_person_id)));
113: -- P_GROUP_ID
114: check_length('GROUP_ID', 'IGS_PE_PERSID_GROUP_ALL', length(TRUNC(p_group_id)));
115: -- Initialize API return status to success
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117: ------------------------------
118: --Intialization of varable to handle G_MISS_CHAR/NUM/DATE