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_GEN_004 dependencies on IGS_CA_INST_ALL

Line 85: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,

81:
82: CURSOR g_c_get_details
83: (
84: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
85: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
86: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE,
87: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
88: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,

Line 86: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE,

82: CURSOR g_c_get_details
83: (
84: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
85: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
86: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE,
87: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
88: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
90: cp_award_prd_cd igf_aw_awd_prd_term.award_prd_cd%TYPE

Line 87: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,

83: (
84: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
85: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
86: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE,
87: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
88: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
90: cp_award_prd_cd igf_aw_awd_prd_term.award_prd_cd%TYPE
91: ) IS

Line 88: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE,

84: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
85: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
86: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE,
87: cp_ld_cal_type igs_ca_inst_all.cal_type%TYPE,
88: cp_ld_sequence_number igs_ca_inst_all.sequence_number%TYPE,
89: cp_fund_id igf_aw_fund_mast.fund_id%TYPE,
90: cp_award_prd_cd igf_aw_awd_prd_term.award_prd_cd%TYPE
91: ) IS
92: SELECT

Line 104: igs_ca_inst_all cai,

100: fmast.description fund_name
101: FROM
102: igf_aw_award_all awd,
103: igf_aw_fund_mast fmast,
104: igs_ca_inst_all cai,
105: igf_aw_awd_disb disb
106: WHERE
107: fmast.ci_cal_type = cp_fa_cal_type AND
108: fmast.ci_sequence_number = cp_fa_sequence_number AND

Line 143: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,

139:
140: CURSOR g_c_get_load_cals
141: (
142: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
143: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
144: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE,
145: cp_award_prd_cd igf_aw_awd_prd_term.award_prd_cd%TYPE
146: ) IS
147: SELECT

Line 144: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE,

140: CURSOR g_c_get_load_cals
141: (
142: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
143: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
144: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE,
145: cp_award_prd_cd igf_aw_awd_prd_term.award_prd_cd%TYPE
146: ) IS
147: SELECT
148: DISTINCT

Line 156: igs_ca_inst_all cai,

152: cai.sequence_number
153: FROM
154: igf_aw_award_all awd,
155: igf_aw_fund_mast fmast,
156: igs_ca_inst_all cai,
157: igf_aw_awd_disb disb
158: WHERE
159: fmast.ci_cal_type = cp_fa_cal_type AND
160: fmast.ci_sequence_number = cp_fa_sequence_number AND

Line 185: p_fa_cal_type igs_ca_inst_all.cal_type%TYPE,

181:
182: --mnade 5/28/2005 Generic function to get base id and avoid join with igf_ap_base_rec_all
183: FUNCTION get_base_id_for_person (
184: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
185: p_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
186: p_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE
187: ) RETURN NUMBER IS
188: CURSOR c_base_id (
189: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

Line 186: p_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE

182: --mnade 5/28/2005 Generic function to get base id and avoid join with igf_ap_base_rec_all
183: FUNCTION get_base_id_for_person (
184: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
185: p_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
186: p_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE
187: ) RETURN NUMBER IS
188: CURSOR c_base_id (
189: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
190: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,

Line 190: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,

186: p_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE
187: ) RETURN NUMBER IS
188: CURSOR c_base_id (
189: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
190: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
191: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE
192: )
193: IS
194: SELECT

Line 191: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE

187: ) RETURN NUMBER IS
188: CURSOR c_base_id (
189: cp_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
190: cp_fa_cal_type igs_ca_inst_all.cal_type%TYPE,
191: cp_fa_sequence_number igs_ca_inst_all.sequence_number%TYPE
192: )
193: IS
194: SELECT
195: base.base_id

Line 1155: igs_ca_inst_all cai,

1151: 2 seq
1152: FROM
1153: igf_aw_award_all awd,
1154: igf_aw_fund_mast fmast,
1155: igs_ca_inst_all cai,
1156: igf_aw_awd_disb disb
1157: WHERE
1158: fmast.ci_cal_type = RTRIM (SUBSTR (p_param1, 1, 10))
1159: AND fmast.ci_sequence_number = TO_NUMBER (RTRIM (SUBSTR (p_param1, 11)))

Line 1420: igs_ca_inst_all cai,

1416: DISTINCT base.person_id
1417: FROM
1418: igf_aw_award_all awd,
1419: igf_aw_fund_mast fmast,
1420: igs_ca_inst_all cai,
1421: igf_aw_awd_disb disb,
1422: igf_ap_fa_base_rec_all base
1423: WHERE
1424: fmast.ci_cal_type = LTRIM(RTRIM(SUBSTR(p_parameter_1, 1, 10))) AND