eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_HE_EXTRACT_FIELDS_PKG dependencies on IGS_CA_INST

Line 848: igs_ca_inst_all cainstall

844: SELECT peresdtls.residency_status_cd residency_status
845: FROM igs_pe_res_dtls_all peresdtls,
846: igs_lookup_values cc1,
847: igs_lookup_values cc2,
848: igs_ca_inst_all cainstall
849: WHERE peresdtls.person_id = p_person_id
850: AND peresdtls.residency_class_cd = cc1.lookup_code
851: AND cc1.lookup_type = 'PE_RES_CLASS'
852: AND peresdtls.residency_status_cd = cc2.lookup_code

Line 1641: igs_ca_inst_rel cir,

1637: SELECT COUNT (DISTINCT cir.sup_ci_sequence_number || cir.sup_cal_type)
1638: FROM igs_he_st_spa_all spa ,
1639: igs_en_stdnt_ps_att sca,
1640: igs_en_su_attempt sua,
1641: igs_ca_inst_rel cir,
1642: igs_ca_inst_all ca
1643: WHERE SPA.person_id = p_person_id and
1644: SPA.student_inst_number = p_student_inst_number AND
1645: SCA.person_id = SPA.person_id AND

Line 1642: igs_ca_inst_all ca

1638: FROM igs_he_st_spa_all spa ,
1639: igs_en_stdnt_ps_att sca,
1640: igs_en_su_attempt sua,
1641: igs_ca_inst_rel cir,
1642: igs_ca_inst_all ca
1643: WHERE SPA.person_id = p_person_id and
1644: SPA.student_inst_number = p_student_inst_number AND
1645: SCA.person_id = SPA.person_id AND
1646: SCA.course_cd = SPA.course_cd AND

Line 3348: igs_ca_inst_all cainstall

3344: SELECT peresdtls.residency_status_cd residency_status
3345: FROM igs_pe_res_dtls_all peresdtls,
3346: igs_lookup_values cc1,
3347: igs_lookup_values cc2,
3348: igs_ca_inst_all cainstall
3349: WHERE peresdtls.person_id = p_person_id
3350: AND peresdtls.residency_class_cd = cc1.lookup_code
3351: AND cc1.lookup_type = 'PE_RES_CLASS'
3352: AND peresdtls.residency_status_cd = cc2.lookup_code

Line 3656: igs_ca_inst ca

3652: igf_aw_award b,
3653: igf_aw_fund_mast fmast,
3654: igf_ap_fa_base_rec c,
3655: igs_he_code_map_val d,
3656: igs_ca_inst ca
3657: WHERE a.award_id = b.award_id
3658: AND b.fund_id = fmast.fund_id
3659: AND b.base_id = c.base_id
3660: AND a.ld_cal_type = ca.cal_type

Line 3683: igs_ca_inst ca

3679: igf_aw_award b,
3680: igf_aw_fund_mast fmast,
3681: igf_ap_fa_base_rec c,
3682: igs_he_code_values d,
3683: igs_ca_inst ca
3684: WHERE a.award_id = b.award_id
3685: AND b.fund_id = fmast.fund_id
3686: AND b.base_id = c.base_id
3687: AND a.ld_cal_type = ca.cal_type

Line 3722: igs_ca_inst ca

3718: igf_aw_award b,
3719: igf_aw_fund_mast fmast,
3720: igf_ap_fa_base_rec c,
3721: igs_he_code_values d,
3722: igs_ca_inst ca
3723: WHERE a.award_id = b.award_id
3724: AND b.fund_id = fmast.fund_id
3725: AND b.base_id = c.base_id
3726: AND a.ld_cal_type = ca.cal_type

Line 3737: CURSOR cur_inv_amt (cp_fee_cal_type igs_ca_inst.cal_type%TYPE,

3733: AND a.trans_type IN ('A' , 'P')
3734: AND ca.start_dt BETWEEN p_enrl_start_dt AND p_enrl_end_dt;
3735:
3736: --Query to get the Invoice amount for the student tution fees
3737: CURSOR cur_inv_amt (cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
3738: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE)
3739: IS
3740: SELECT NVL(SUM(inv.invoice_amount),0) invoice_amount
3741: FROM igs_fi_inv_int inv,

Line 3738: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE)

3734: AND ca.start_dt BETWEEN p_enrl_start_dt AND p_enrl_end_dt;
3735:
3736: --Query to get the Invoice amount for the student tution fees
3737: CURSOR cur_inv_amt (cp_fee_cal_type igs_ca_inst.cal_type%TYPE,
3738: cp_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE)
3739: IS
3740: SELECT NVL(SUM(inv.invoice_amount),0) invoice_amount
3741: FROM igs_fi_inv_int inv,
3742: igs_fi_fee_type ft

Line 3755: l_fee_cal_type igs_ca_inst.cal_type%TYPE;

3751: l_he_code_map_val igs_he_code_map_val%ROWTYPE;
3752: l_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;
3753: l_tot_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;
3754: l_message_name fnd_new_messages.message_name%TYPE;
3755: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
3756: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
3757:
3758: BEGIN
3759:

Line 3756: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

3752: l_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;
3753: l_tot_invoice_amt igs_fi_inv_int.invoice_amount%TYPE;
3754: l_message_name fnd_new_messages.message_name%TYPE;
3755: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
3756: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
3757:
3758: BEGIN
3759:
3760: l_value := NULL;

Line 5282: l_prev_start_dt IGS_CA_INST.start_dt%TYPE;

5278: ***************************************************************/
5279:
5280: l_he_code_map_val IGS_HE_CODE_MAP_VAL%ROWTYPE := NULL;
5281: l_progression_out_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE;
5282: l_prev_start_dt IGS_CA_INST.start_dt%TYPE;
5283: l_prev_applied_dt IGS_PR_STDNT_PR_OU.applied_dt%TYPE;
5284: l_prev_decision_dt IGS_PR_STDNT_PR_OU.decision_dt%TYPE;
5285: l_minimum_date DATE;
5286:

Line 5294: IGS_CA_INST ca

5290: cp_enrl_start_dt igs_he_submsn_header.enrolment_start_date%TYPE,
5291: cp_enrl_end_dt igs_he_submsn_header.enrolment_end_date%TYPE) IS
5292: SELECT progression_outcome_type,ca.start_dt , spo.decision_dt, spo.applied_dt
5293: FROM IGS_PR_STDNT_PR_OU spo,
5294: IGS_CA_INST ca
5295: WHERE spo.person_id = cp_person_id AND
5296: spo.course_cd = cp_course_cd AND
5297: -- Select Approved Progression Outcomes
5298: spo.decision_status = 'APPROVED' AND