APPS.IGS_PRECREATE_APPL_PUB dependencies on HZ_PARTIES

Line 77: CURSOR c_person(p_person_id hz_parties.party_id%TYPE) IS

73: l_return_status VARCHAR2(1);
74: l_hash_msg_name_text_type_tab igs_ad_gen_016.g_msg_name_text_type_table;
75:
76: -- Cursor to validate person
77: CURSOR c_person(p_person_id hz_parties.party_id%TYPE) IS
78: SELECT party_id
79: FROM hz_parties hzp
80: WHERE hzp.party_id = p_person_id;
81:

Line 79: FROM hz_parties hzp

75:
76: -- Cursor to validate person
77: CURSOR c_person(p_person_id hz_parties.party_id%TYPE) IS
78: SELECT party_id
79: FROM hz_parties hzp
80: WHERE hzp.party_id = p_person_id;
81:
82: -- Cursor to validate Entry Status
83: CURSOR c_estatus(p_estatus IGS_AD_CODE_CLASSES.code_id%TYPE) IS

Line 183: l_person_rec igs_pe_hz_parties.party_id%TYPE := NULL;

179: s_admission_process_type = p_s_adm_process_type AND
180: s_admission_step_type = 'LATE-APP' AND
181: mandatory_step_ind = 'Y';
182:
183: l_person_rec igs_pe_hz_parties.party_id%TYPE := NULL;
184: l_estatus_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
185: l_elevel_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
186: l_spcl_grp1_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;
187: l_spcl_grp2_rec IGS_AD_CODE_CLASSES.CODE_ID%TYPE := NULL;