DBA Data[Home] [Help]

APPS.IGS_EN_FUTURE_DT_TRANS dependencies on HZ_PARTIES

Line 2315: FROM HZ_PARTIES

2311:
2312: -- cursor to get the person number
2313: CURSOR c_person_num(cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE) IS
2314: SELECT party_number
2315: FROM HZ_PARTIES
2316: WHERE party_id = cp_person_id;
2317:
2318: -- cursor to get the load calendar end date
2319: CURSOR c_load_cal_end_dt(cp_term_cal IGS_CA_INST.cal_type%TYPE,

Line 2407: v_person_num HZ_PARTIES.party_number%TYPE;

2403: l_term_cal_type IGS_CA_DA_INST.cal_type%TYPE;
2404: l_term_sequence_number IGS_CA_DA_INST.sequence_number%TYPE;
2405: l_end_dt IGS_CA_INST.end_dt%TYPE;
2406: v_del BOOLEAN;
2407: v_person_num HZ_PARTIES.party_number%TYPE;
2408: l_acad_cal_seq_num IGS_CA_DA_INST.sequence_number%TYPE;
2409: l_acad_cal_type IGS_CA_DA_INST.cal_type%TYPE;
2410: l_message_name VARCHAR2(30);
2411: l_show_warning VARCHAR2(1);