APPS.IGS_AV_GEN_001 dependencies on HZ_PARTIES

Line 36: swaghmar 15-Jun-2005 Bug# 4377816. Changed the cursor queries to pick party_number from igs_pe_hz_parties instead of hz_parties

32: rvivekan 09-sep-2003 Modified the behaviour of repeatable_ind column in igs_ps_unit_ver table. PSP integration build #3052433
33: stutta 27-Oct-2003 Modified funcion advp_upd_sua_advstnd by removing calls to functions IGS_EN_VAL_SUA.enrp_val_sca_supunit,
34: IGS_EN_VAL_SUA.enrp_val_sca_subunit as part of build #3052438
35: nalkumar 10-Dec-2003 Bug# 3270446 RECR50 Build; Obsoleted the IGS_AV_STND_UNIT.CREDIT_PERCENTAGE column.
36: swaghmar 15-Jun-2005 Bug# 4377816. Changed the cursor queries to pick party_number from igs_pe_hz_parties instead of hz_parties
37: sgurusam 17-Jun-2005 Modified to pass aditional parameter p_calling_obj = 'JOB' in the calls to
38: igs_en_elgbl_unit.eval_unit_repeat
39: jhanda 10-july-05 Build 4327991 BUILD FOR RE105 TRANSFER EVALUATION UI ENHANCEMENTS
40:

Line 490: cp_exemption_institution_cd igs_pe_hz_parties.inst_org_ind%TYPE) IS

486: AND suc.version_number = p_version_number
487: GROUP BY suc.exemption_institution_cd
488: ORDER BY SUM (suc.credit) DESC;
489: CURSOR c_exempt_inst_v (
490: cp_exemption_institution_cd igs_pe_hz_parties.inst_org_ind%TYPE) IS
491: SELECT 'x'
492: FROM igs_pe_hz_parties ihp
493: where ihp.inst_org_ind = 'I'
494: AND ihp.oi_govt_institution_cd IS NOT NULL

Line 492: FROM igs_pe_hz_parties ihp

488: ORDER BY SUM (suc.credit) DESC;
489: CURSOR c_exempt_inst_v (
490: cp_exemption_institution_cd igs_pe_hz_parties.inst_org_ind%TYPE) IS
491: SELECT 'x'
492: FROM igs_pe_hz_parties ihp
493: where ihp.inst_org_ind = 'I'
494: AND ihp.oi_govt_institution_cd IS NOT NULL
495: AND ihp.oss_org_unit_cd = cp_exemption_institution_cd
496: UNION ALL

Line 505: FROM hz_parties hp,

501: AND lk.lookup_code = cp_exemption_institution_cd;
502: CURSOR c_institution (
503: cp_exemption_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE) IS
504: SELECT 'x'
505: FROM hz_parties hp,
506: igs_pe_hz_parties ihp
507: WHERE ihp.oss_org_unit_cd = cp_exemption_institution_cd --swaghmar bug# 4377816
508: AND hp.party_id = ihp.party_id
509: AND ihp.inst_org_ind = 'I'

Line 506: igs_pe_hz_parties ihp

502: CURSOR c_institution (
503: cp_exemption_institution_cd IGS_OR_INSTITUTION.institution_cd%TYPE) IS
504: SELECT 'x'
505: FROM hz_parties hp,
506: igs_pe_hz_parties ihp
507: WHERE ihp.oss_org_unit_cd = cp_exemption_institution_cd --swaghmar bug# 4377816
508: AND hp.party_id = ihp.party_id
509: AND ihp.inst_org_ind = 'I'
510: AND ihp.oi_os_ind = 'Y';

Line 879: FROM hz_parties

875: AND version_number = v_asu_rec.version_number;
876:
877: CURSOR cur_get_person_num IS
878: SELECT party_number
879: FROM hz_parties
880: WHERE party_id = p_person_id;
881: l_cur_get_person_num cur_get_person_num%ROWTYPE;
882: l_message_name fnd_new_messages.message_name%TYPE;
883: l_repeat_tag VARCHAR2(100);

Line 1417: FROM hz_parties

1413: daiv.alias_val DESC;
1414:
1415: CURSOR cur_get_person_num IS
1416: SELECT party_number
1417: FROM hz_parties
1418: WHERE party_id = p_person_id;
1419: l_cur_get_person_num cur_get_person_num%ROWTYPE;
1420:
1421: gv_other_detail VARCHAR2(255);

Line 2294: FROM igs_av_stnd_unit_all a, igs_pe_hz_parties ipz

2290: usverno VARCHAR2
2291: )
2292: IS
2293: SELECT SUM (a.achievable_credit_points)
2294: FROM igs_av_stnd_unit_all a, igs_pe_hz_parties ipz
2295: WHERE a.s_adv_stnd_granting_status = 'GRANTED'
2296: AND a.s_adv_stnd_recognition_type = 'CREDIT'
2297: AND a.exemption_institution_cd(+) = ipz.oss_org_unit_cd
2298: AND (a.cal_type, a.ci_sequence_number) IN (

Line 2312: FROM igs_av_stnd_unit_lvl_all a, igs_pe_hz_parties ipz

2308:
2309: CURSOR c_credit_pts_3 (personid NUMBER, coursecd VARCHAR2)
2310: IS
2311: SELECT SUM (a.credit_points)
2312: FROM igs_av_stnd_unit_lvl_all a, igs_pe_hz_parties ipz
2313: WHERE a.s_adv_stnd_granting_status = 'GRANTED'
2314: AND a.exemption_institution_cd(+) = ipz.oss_org_unit_cd
2315: AND (personid = person_id)
2316: AND (coursecd = as_course_cd);