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.IGF_AW_PACKAGING dependencies on IGS_CA_INST_ALL

Line 300: g_ci_cal_type igs_ca_inst_all.cal_type%TYPE;

296: -- g_sf_packaging VARCHAR2(1) := 'F';
297: g_sf_packaging VARCHAR2(1);
298: g_allow_to_exceed igf_lookups_view.lookup_code%TYPE;
299: g_fm_fc_methd igf_aw_fund_mast_all.fm_fc_methd%TYPE;
300: g_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
301: g_ci_sequence igs_ca_inst_all.sequence_number%TYPE;
302: g_sf_fund igf_aw_fund_mast_all.fund_id%TYPE;
303:
304: g_pell_tab igf_gr_pell_calc.pell_tab := igf_gr_pell_calc.pell_tab();

Line 301: g_ci_sequence igs_ca_inst_all.sequence_number%TYPE;

297: g_sf_packaging VARCHAR2(1);
298: g_allow_to_exceed igf_lookups_view.lookup_code%TYPE;
299: g_fm_fc_methd igf_aw_fund_mast_all.fm_fc_methd%TYPE;
300: g_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
301: g_ci_sequence igs_ca_inst_all.sequence_number%TYPE;
302: g_sf_fund igf_aw_fund_mast_all.fund_id%TYPE;
303:
304: g_pell_tab igf_gr_pell_calc.pell_tab := igf_gr_pell_calc.pell_tab();
305:

Line 727: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;

723: --
724: --Change History:
725: --Who When What
726: -------------------------------------------------------------------
727: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
728: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
729:
730: CURSOR c_awards IS
731: SELECT awd.ROWID row_id,

Line 728: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;

724: --Change History:
725: --Who When What
726: -------------------------------------------------------------------
727: l_ci_cal_type igs_ca_inst_all.cal_type%TYPE;
728: l_ci_sequence_number igs_ca_inst_all.sequence_number%TYPE;
729:
730: CURSOR c_awards IS
731: SELECT awd.ROWID row_id,
732: awd.*

Line 5814: igs_ca_inst_all cal_inst,

5810: ant_data.ld_cal_type load_cal_type,
5811: ant_data.ld_sequence_number load_seq_num
5812: FROM
5813: igf_aw_awd_prd_term awd_per,
5814: igs_ca_inst_all cal_inst,
5815: igf_ap_fa_ant_data ant_data,
5816: igs_ps_ver prog
5817: WHERE
5818: awd_per.ld_cal_type = cal_inst.cal_type AND

Line 12126: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

12122:
12123: CURSOR c_base_attendance(
12124: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
12125: cp_award_id igf_aw_award_all.award_id%TYPE,
12126: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
12127: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
12128: ) IS
12129: SELECT awdt.temp_char2_txt base_attendance_type_code
12130: FROM igf_aw_award_t awdt

Line 12127: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE

12123: CURSOR c_base_attendance(
12124: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
12125: cp_award_id igf_aw_award_all.award_id%TYPE,
12126: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
12127: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE
12128: ) IS
12129: SELECT awdt.temp_char2_txt base_attendance_type_code
12130: FROM igf_aw_award_t awdt
12131: WHERE process_id = l_process_id

Line 13047: FROM igs_ca_inst_all

13043: CURSOR c_alternate_code(
13044: cp_award_year VARCHAR2
13045: ) IS
13046: SELECT alternate_code
13047: FROM igs_ca_inst_all
13048: WHERE cal_type = TRIM(SUBSTR(cp_award_year,1,10))
13049: AND sequence_number = TO_NUMBER(SUBSTR(p_award_year,11));
13050:
13051: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

Line 13051: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;

13047: FROM igs_ca_inst_all
13048: WHERE cal_type = TRIM(SUBSTR(cp_award_year,1,10))
13049: AND sequence_number = TO_NUMBER(SUBSTR(p_award_year,11));
13050:
13051: l_alternate_code igs_ca_inst_all.alternate_code%TYPE;
13052:
13053: -- Get get group description for group_id
13054: CURSOR c_person_group(
13055: cp_persid_grp igs_pe_persid_group_all.group_id%TYPE