APPS.IGS_AD_WF_P2A dependencies on IGS_PE_HZ_PARTIES

Line 82: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;

78: CURSOR c_seq_num IS
79: SELECT IGS_SS_ADM_APPL_S.NEXTVAL
80: FROM sys.dual;
81:
82: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
83: l_login_role VARCHAR2(30);
84: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
85: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
86: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;

Line 307: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;

303: CURSOR c_appl_fee_uhk_prl IS
304: SELECT FND_PROFILE.VALUE('IGS_AD_APPL_FEE_UHK') value
305: FROM dual;
306:
307: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
308: l_login_role VARCHAR2(30);
309: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
310: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
311: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;

Line 875: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;

871: admission_cat = p_admission_cat AND
872: s_admission_process_type = p_s_admission_process_type;
873:
874:
875: l_person_id IGS_PE_HZ_PARTIES.party_id%TYPE;
876: l_login_role VARCHAR2(30);
877: l_acad_cal_type IGS_CA_INST_ALL.cal_type%TYPE;
878: l_acad_cal_seq_number IGS_CA_INST_ALL.sequence_number%TYPE;
879: l_adm_cal_type IGS_CA_INST_ALL.cal_type%TYPE;