APPS.IGS_AD_ADM_REQ dependencies on HZ_PARTIES

Line 180: CURSOR c_get_person_number (cp_person_id hz_parties.party_id%TYPE) IS

176: AND lookup_code = p_requirements_type;
177:
178: get_meaning_req_type_rec get_meaning_req_type_cur%ROWTYPE;
179:
180: CURSOR c_get_person_number (cp_person_id hz_parties.party_id%TYPE) IS
181: SELECT party_number person_number
182: FROM hz_parties
183: WHERE party_id = cp_person_id;
184:

Line 182: FROM hz_parties

178: get_meaning_req_type_rec get_meaning_req_type_cur%ROWTYPE;
179:
180: CURSOR c_get_person_number (cp_person_id hz_parties.party_id%TYPE) IS
181: SELECT party_number person_number
182: FROM hz_parties
183: WHERE party_id = cp_person_id;
184:
185: l_get_person_number hz_parties.party_number%TYPE;
186:

Line 185: l_get_person_number hz_parties.party_number%TYPE;

181: SELECT party_number person_number
182: FROM hz_parties
183: WHERE party_id = cp_person_id;
184:
185: l_get_person_number hz_parties.party_number%TYPE;
186:
187:
188: BEGIN
189: -- Initialize message stack

Line 423: l_originator_person_id hz_parties.party_id%type;

419: ) RETURN BOOLEAN AS
420:
421: l_message_name VARCHAR2(30);
422: l_target_days igs_tr_type.target_days%TYPE;
423: l_originator_person_id hz_parties.party_id%type;
424:
425: CURSOR trk_comp_dt_cur IS
426: SELECT
427: NVL(TRUNC(IGS_CA_GEN_001.calp_set_alias_value(