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_FI_GEN_001 dependencies on IGS_FI_FEE_AS

Line 211: CURSOR c_far ( cp_fee_type IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE,

207: SELECT currency_cd
208: FROM IGS_FI_FEE_CAT fc
209: WHERE FEE_CAT = cp_fee_cat;
210: -- this cursor finds the relation type value for a fee ass rate
211: CURSOR c_far ( cp_fee_type IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE,
212: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
213: cp_fee_ci_seq_num
214: IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
215: cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS

Line 212: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,

208: FROM IGS_FI_FEE_CAT fc
209: WHERE FEE_CAT = cp_fee_cat;
210: -- this cursor finds the relation type value for a fee ass rate
211: CURSOR c_far ( cp_fee_type IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE,
212: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
213: cp_fee_ci_seq_num
214: IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
215: cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS
216: SELECT DISTINCT

Line 214: IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,

210: -- this cursor finds the relation type value for a fee ass rate
211: CURSOR c_far ( cp_fee_type IGS_FI_FEE_AS_RATE.FEE_TYPE%TYPE,
212: cp_fee_cal_type IGS_FI_FEE_AS_RATE.fee_cal_type%TYPE,
213: cp_fee_ci_seq_num
214: IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
215: cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS
216: SELECT DISTINCT
217: s_relation_type
218: FROM IGS_FI_FEE_AS_RATE

Line 218: FROM IGS_FI_FEE_AS_RATE

214: IGS_FI_FEE_AS_RATE.fee_ci_sequence_number%TYPE,
215: cp_fee_cat IGS_FI_FEE_CAT.FEE_CAT%TYPE) IS
216: SELECT DISTINCT
217: s_relation_type
218: FROM IGS_FI_FEE_AS_RATE
219: WHERE FEE_TYPE = cp_fee_type AND
220: fee_cal_type = cp_fee_cal_type AND
221: fee_ci_sequence_number = cp_fee_ci_seq_num AND
222: NVL(FEE_CAT, cp_fee_cat) = cp_fee_cat;

Line 225: v_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE;

221: fee_ci_sequence_number = cp_fee_ci_seq_num AND
222: NVL(FEE_CAT, cp_fee_cat) = cp_fee_cat;
223:
224: v_currency_cd igs_fi_control.currency_cd%TYPE;
225: v_s_relation_type IGS_FI_FEE_AS_RATE.s_relation_type%TYPE;
226: l_ctrl_currency igs_fi_control.currency_cd%TYPE;
227:
228: BEGIN
229: OPEN cur_ctrl;

Line 312: CURSOR c_fee_ass (cp_person_id IGS_FI_FEE_AS.person_id%TYPE,

308: RETURN VARCHAR2 AS
309:
310: BEGIN
311: DECLARE
312: CURSOR c_fee_ass (cp_person_id IGS_FI_FEE_AS.person_id%TYPE,
313: cp_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,
314: cp_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
315: cp_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
316: cp_fee_cat IGS_FI_FEE_AS.FEE_CAT%TYPE,

Line 313: cp_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,

309:
310: BEGIN
311: DECLARE
312: CURSOR c_fee_ass (cp_person_id IGS_FI_FEE_AS.person_id%TYPE,
313: cp_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,
314: cp_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
315: cp_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
316: cp_fee_cat IGS_FI_FEE_AS.FEE_CAT%TYPE,
317: cp_course_cd IGS_FI_FEE_AS.course_cd%TYPE,

Line 314: cp_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,

310: BEGIN
311: DECLARE
312: CURSOR c_fee_ass (cp_person_id IGS_FI_FEE_AS.person_id%TYPE,
313: cp_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,
314: cp_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
315: cp_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
316: cp_fee_cat IGS_FI_FEE_AS.FEE_CAT%TYPE,
317: cp_course_cd IGS_FI_FEE_AS.course_cd%TYPE,
318: cp_transaction_cat IGS_LOOKUPS_view.transaction_cat%TYPE) IS

Line 315: cp_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,

311: DECLARE
312: CURSOR c_fee_ass (cp_person_id IGS_FI_FEE_AS.person_id%TYPE,
313: cp_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,
314: cp_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
315: cp_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
316: cp_fee_cat IGS_FI_FEE_AS.FEE_CAT%TYPE,
317: cp_course_cd IGS_FI_FEE_AS.course_cd%TYPE,
318: cp_transaction_cat IGS_LOOKUPS_view.transaction_cat%TYPE) IS
319: SELECT fas.s_transaction_type

Line 316: cp_fee_cat IGS_FI_FEE_AS.FEE_CAT%TYPE,

312: CURSOR c_fee_ass (cp_person_id IGS_FI_FEE_AS.person_id%TYPE,
313: cp_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,
314: cp_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
315: cp_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
316: cp_fee_cat IGS_FI_FEE_AS.FEE_CAT%TYPE,
317: cp_course_cd IGS_FI_FEE_AS.course_cd%TYPE,
318: cp_transaction_cat IGS_LOOKUPS_view.transaction_cat%TYPE) IS
319: SELECT fas.s_transaction_type
320: FROM IGS_FI_FEE_AS fas,

Line 317: cp_course_cd IGS_FI_FEE_AS.course_cd%TYPE,

313: cp_fee_type IGS_FI_FEE_AS.FEE_TYPE%TYPE,
314: cp_fee_cal_type IGS_FI_FEE_AS.fee_cal_type%TYPE,
315: cp_fee_ci_sequence_number IGS_FI_FEE_AS.fee_ci_sequence_number%TYPE,
316: cp_fee_cat IGS_FI_FEE_AS.FEE_CAT%TYPE,
317: cp_course_cd IGS_FI_FEE_AS.course_cd%TYPE,
318: cp_transaction_cat IGS_LOOKUPS_view.transaction_cat%TYPE) IS
319: SELECT fas.s_transaction_type
320: FROM IGS_FI_FEE_AS fas,
321: IGS_LOOKUPS_view strty

Line 320: FROM IGS_FI_FEE_AS fas,

316: cp_fee_cat IGS_FI_FEE_AS.FEE_CAT%TYPE,
317: cp_course_cd IGS_FI_FEE_AS.course_cd%TYPE,
318: cp_transaction_cat IGS_LOOKUPS_view.transaction_cat%TYPE) IS
319: SELECT fas.s_transaction_type
320: FROM IGS_FI_FEE_AS fas,
321: IGS_LOOKUPS_view strty
322: WHERE fas.person_id = cp_person_id AND
323: fas.fee_type = cp_fee_type AND
324: fas.fee_cal_type = cp_fee_cal_type AND

Line 333: v_transaction_type IGS_FI_FEE_AS.S_TRANSACTION_TYPE%TYPE;

329: strty.lookup_code = fas.s_transaction_type AND
330: strty.lookup_type = 'TRANSACTION_TYPE' AND
331: strty.transaction_cat = cp_transaction_cat AND
332: strty.system_generated_ind = 'N';
333: v_transaction_type IGS_FI_FEE_AS.S_TRANSACTION_TYPE%TYPE;
334: BEGIN
335: -- attempt to find manual entry transactions
336: OPEN c_fee_ass(p_person_id,
337: p_fee_type,

Line 1134: IGS_FI_FEE_AS fas

1130: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1131: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1132: SELECT SUM(fas.transaction_amount/fas.exchange_rate)
1133: FROM IGS_FI_FEE_TYPE ft,
1134: IGS_FI_FEE_AS fas
1135: WHERE ft.s_fee_type = cst_hecs AND
1136: fas.person_id = p_person_id AND
1137: fas.course_cd = p_course_cd AND
1138: fas.FEE_TYPE = ft.FEE_TYPE AND

Line 1196: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.

1192: Change History
1193: Who When What
1194: uudayapr 12-12-2003 bug#3080983 made the modification to the
1195: Cursor c_fp_total to point to the table
1196: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
1197: schodava 21-Jan-2002 Enh # 2187247
1198: SFCR021 - LCI-FCI Relation
1199: ******************************************************************/
1200: -- finp_get_hecs_fee

Line 1208: --modification to the Cursor c_fp_total to point to the table IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.

1204: v_fp_total NUMBER;
1205: v_fee_cal_type igs_ca_inst.cal_type%TYPE;
1206: v_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
1207: v_message_name fnd_new_messages.message_name%TYPE;
1208: --modification to the Cursor c_fp_total to point to the table IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
1209: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1210: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1211: SELECT SUM(fadv.transaction_amount/fadv.exchange_rate) local_assessment_amount
1212: FROM IGS_FI_FEE_TYPE ft,

Line 1213: IGS_FI_FEE_AS fadv

1209: CURSOR c_fp_total(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1210: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1211: SELECT SUM(fadv.transaction_amount/fadv.exchange_rate) local_assessment_amount
1212: FROM IGS_FI_FEE_TYPE ft,
1213: IGS_FI_FEE_AS fadv
1214: WHERE ft.s_fee_type = cst_hecs
1215: AND fadv.person_id = p_person_id
1216: AND ((fadv.course_cd = p_course_cd) OR ( fadv.course_cd IS NULL AND p_course_cd IS NULL))
1217: AND fadv.FEE_TYPE = ft.FEE_TYPE

Line 1355: IGS_FI_FEE_ASS_DEBT_V.local_assessment_amount%TYPE

1351: Change History
1352: Who When What
1353: uudayapr 12-12-2003 bug#3080983 made the modification to v_loc_ass_amt
1354: declartion as number instead
1355: IGS_FI_FEE_ASS_DEBT_V.local_assessment_amount%TYPE
1356: and the Cursor c_local_ass_amt to point to the table
1357: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
1358: Modified teh cst_tuition instialization to TUTNFEE
1359: instead of TUITION .

Line 1357: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.

1353: uudayapr 12-12-2003 bug#3080983 made the modification to v_loc_ass_amt
1354: declartion as number instead
1355: IGS_FI_FEE_ASS_DEBT_V.local_assessment_amount%TYPE
1356: and the Cursor c_local_ass_amt to point to the table
1357: IGS_FI_FEE_AS instead IGS_FI_FEE_ASS_DEBT_V view.
1358: Modified teh cst_tuition instialization to TUTNFEE
1359: instead of TUITION .
1360:
1361: schodava 21-Jan-2002 Enh # 2187247

Line 1375: IGS_FI_FEE_AS fadv

1371: CURSOR c_local_ass_amt(cp_fee_cal_type IN igs_ca_inst.cal_type%TYPE,
1372: cp_fee_ci_sequence_number IN igs_ca_inst.sequence_number%TYPE) IS
1373: SELECT SUM(fadv.transaction_amount/fadv.exchange_rate) local_assessment_amount
1374: FROM IGS_FI_FEE_TYPE ft,
1375: IGS_FI_FEE_AS fadv
1376: WHERE ft.s_fee_type = cst_tuition
1377: AND fadv.person_id = p_person_id
1378: AND ((fadv.course_cd = p_course_cd ) OR (fadv.course_cd IS NULL AND p_course_cd IS NULL))
1379: AND fadv.FEE_TYPE = ft.FEE_TYPE

Line 1390: -- is developed. It will require a look up on the IGS_FI_FEE_AS

1386: -- fully-funded by an employer, then a 0 value is returned.
1387: -- This routine has been developed for use by the statistics
1388: -- sub-system (STAP_INS_GOVT_SNPSHT).
1389: -- It will need to be re-written when the finance sub-system
1390: -- is developed. It will require a look up on the IGS_FI_FEE_AS
1391: -- table tuition fee not charged or the student is in a place fully-
1392: -- funded by an employer.
1393: -- Get the total assessed for fee category fee liability assessments
1394: -- associated with a TUITION fee with respect to the load calendar.