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 IGF_AP_BATCH_AW_MAP_ALL

Line 8275: FROM igf_ap_batch_aw_map_all

8271: cp_ci_cal_type igs_ca_inst.cal_type%TYPE,
8272: cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE
8273: ) IS
8274: SELECT pell_participant_code
8275: FROM igf_ap_batch_aw_map_all
8276: WHERE ci_cal_type = cp_ci_cal_type
8277: AND ci_sequence_number = cp_ci_sequence_number;
8278: l_pell_participant_code igf_ap_batch_aw_map_all.pell_participant_code%TYPE;
8279:

Line 8278: l_pell_participant_code igf_ap_batch_aw_map_all.pell_participant_code%TYPE;

8274: SELECT pell_participant_code
8275: FROM igf_ap_batch_aw_map_all
8276: WHERE ci_cal_type = cp_ci_cal_type
8277: AND ci_sequence_number = cp_ci_sequence_number;
8278: l_pell_participant_code igf_ap_batch_aw_map_all.pell_participant_code%TYPE;
8279:
8280: BEGIN
8281: l_pell_participant_code := NULL;
8282: OPEN c_pell_particip(p_ci_cal_type,p_ci_sequence_number);

Line 8513: igf_ap_batch_aw_map_all bam

8509: COUNT(awd.award_id) lf_count
8510: FROM igf_aw_award_all awd,
8511: igf_aw_fund_mast_all fmast,
8512: igf_ap_fa_base_rec fabase,
8513: igf_ap_batch_aw_map_all bam
8514: WHERE fmast.fund_code = cp_fund_code
8515: AND awd.fund_id = fmast.fund_id
8516: AND awd.base_id = fabase.base_id
8517: AND fabase.person_id = cp_person_id