APPS.IGS_EN_ELGBL_OVERRIDE dependencies on HZ_PARTIES

Line 212: FROM hz_parties PE

208: WHERE PG.group_id = p_person_id_group;
209:
210: CURSOR cur_person_id(p_person_id NUMBER) IS
211: SELECT PE.party_number person_number
212: FROM hz_parties PE
213: WHERE PE.party_id = p_person_id;
214:
215: CURSOR cur_step(p_lookup_type VARCHAR2, p_step VARCHAR2) IS
216: SELECT LKV.meaning

Line 781: FROM hz_parties

777: lr_cur_check_override cur_check_override%ROWTYPE;
778:
779: CURSOR cur_pers_number(p_party_id NUMBER)IS
780: SELECT party_number
781: FROM hz_parties
782: WHERE party_id = p_party_id;
783:
784: l_person_number hz_parties.party_number%TYPE;
785:

Line 784: l_person_number hz_parties.party_number%TYPE;

780: SELECT party_number
781: FROM hz_parties
782: WHERE party_id = p_party_id;
783:
784: l_person_number hz_parties.party_number%TYPE;
785:
786: CURSOR cur_step_meaning (cp_step_Type IGS_LOOKUP_VALUES.LOOKUP_CODE%TYPE) IS
787: SELECT meaning
788: FROM igs_lookup_values