APPS.IGS_EN_SVS_AUTH_CAL_PKG dependencies on HZ_PARTIES

Line 233: CURSOR c_another_auth (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS

229: AND esa.person_id = eeo.person_id
230: AND eeo.cal_type = x_cal_type
231: AND eeo.ci_sequence_number = x_ci_sequence_number;
232:
233: CURSOR c_another_auth (cp_person_id HZ_PARTIES.PARTY_ID%TYPE) IS
234: SELECT 'X'
235: FROM IGS_EN_SVS_AUTH_CAL sac, IGS_EN_SVS_AUTH esa
236: WHERE esa.SEVIS_AUTH_ID <> x_sevis_auth_id
237: AND esa.person_id = cp_person_id

Line 251: l_person_id HZ_PARTIES.PARTY_ID%TYPE;

247:
248: l_elgb_override_id IGS_EN_ELGB_OVR.ELGB_OVERRIDE_ID%TYPE;
249: l_step_override_type IGS_EN_ELGB_OVR_STEP.step_override_type%TYPE;
250: l_step_override_limit IGS_EN_ELGB_OVR_STEP.step_override_limit%TYPE;
251: l_person_id HZ_PARTIES.PARTY_ID%TYPE;
252: l_dummy VARCHAR2(10);
253: l_rowid VARCHAR2(25);
254:
255: BEGIN

Line 419: CURSOR c_ovr_step (cp_person_id hz_parties.party_id%TYPE,

415: FROM igs_en_svs_auth
416: WHERE sevis_auth_id = x_sevis_auth_id;
417:
418:
419: CURSOR c_ovr_step (cp_person_id hz_parties.party_id%TYPE,
420: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
421: cp_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE)IS
422: SELECT STEP_OVERRIDE_TYPE, STEP_OVERRIDE_LIMIT
423: FROM IGS_EN_ELGB_OVR_STEP eos, IGS_EN_ELGB_OVR eo

Line 434: l_person_id hz_parties.party_id%TYPE;

430:
431:
432: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE;
433: l_ci_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE;
434: l_person_id hz_parties.party_id%TYPE;
435: l_elgb_override_id igs_en_elgb_ovr.elgb_override_id%TYPE;
436: l_step IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_TYPE%TYPE;
437: l_limit IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_LIMIT%TYPE;
438: