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_006 dependencies on IGS_EN_STDNTPSHECSOP

Line 144: SELECT IGS_EN_STDNTPSHECSOP.*, rowid

140: CURSOR c_scho(
141: cp_effective_dt DATE,
142: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
143: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
144: SELECT IGS_EN_STDNTPSHECSOP.*, rowid
145: FROM IGS_EN_STDNTPSHECSOP
146: WHERE person_id = cp_person_id AND
147: course_cd = cp_course_cd AND
148: TRUNC(cp_effective_dt) >= TRUNC(start_dt) AND

Line 145: FROM IGS_EN_STDNTPSHECSOP

141: cp_effective_dt DATE,
142: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
143: cp_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE) IS
144: SELECT IGS_EN_STDNTPSHECSOP.*, rowid
145: FROM IGS_EN_STDNTPSHECSOP
146: WHERE person_id = cp_person_id AND
147: course_cd = cp_course_cd AND
148: TRUNC(cp_effective_dt) >= TRUNC(start_dt) AND
149: TRUNC(cp_effective_dt) <= TRUNC(NVL(end_dt, cp_effective_dt))

Line 210: FROM IGS_EN_STDNTPSHECSOP

206: cp_end_dt DATE) IS
207: SELECT tax_file_number,
208: tax_file_number_collected_dt,
209: tax_file_certificate_number
210: FROM IGS_EN_STDNTPSHECSOP
211: WHERE person_id = p_person_id AND
212: course_cd = p_course_cd AND
213: start_dt > cp_end_dt AND
214: (tax_file_number IS NOT NULL AND

Line 224: v_tax_file_number IGS_EN_STDNTPSHECSOP.tax_file_number%TYPE;

220: v_ghpo_rec c_ghpo%ROWTYPE;
221: v_scho_rec c_scho%ROWTYPE;
222: v_assessment_amount_sum NUMBER;
223: v_payment_amount_sum NUMBER;
224: v_tax_file_number IGS_EN_STDNTPSHECSOP.tax_file_number%TYPE;
225: v_tax_file_number_collected_dt
226: IGS_EN_STDNTPSHECSOP.tax_file_number_collected_dt%TYPE;
227: v_tax_file_certificate_number
228: IGS_EN_STDNTPSHECSOP.tax_file_certificate_number%TYPE;

Line 226: IGS_EN_STDNTPSHECSOP.tax_file_number_collected_dt%TYPE;

222: v_assessment_amount_sum NUMBER;
223: v_payment_amount_sum NUMBER;
224: v_tax_file_number IGS_EN_STDNTPSHECSOP.tax_file_number%TYPE;
225: v_tax_file_number_collected_dt
226: IGS_EN_STDNTPSHECSOP.tax_file_number_collected_dt%TYPE;
227: v_tax_file_certificate_number
228: IGS_EN_STDNTPSHECSOP.tax_file_certificate_number%TYPE;
229: v_deferred_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE
230: DEFAULT p_deferred_payment_option;

Line 228: IGS_EN_STDNTPSHECSOP.tax_file_certificate_number%TYPE;

224: v_tax_file_number IGS_EN_STDNTPSHECSOP.tax_file_number%TYPE;
225: v_tax_file_number_collected_dt
226: IGS_EN_STDNTPSHECSOP.tax_file_number_collected_dt%TYPE;
227: v_tax_file_certificate_number
228: IGS_EN_STDNTPSHECSOP.tax_file_certificate_number%TYPE;
229: v_deferred_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE
230: DEFAULT p_deferred_payment_option;
231: v_upfront_payment_option IGS_FI_HECS_PAY_OPTN.HECS_PAYMENT_OPTION%TYPE
232: DEFAULT p_upfront_payment_option;

Line 399: -- end the current IGS_EN_STDNTPSHECSOP entry

395: ELSE -- valid
396: p_hecs_payment_type := 'DEFERRED';
397: IF p_update_ind = 'Y' THEN
398: IF TRUNC(v_scho_rec.start_dt) <> TRUNC(p_effective_dt) THEN
399: -- end the current IGS_EN_STDNTPSHECSOP entry
400: IGS_EN_STDNTPSHECSOP_Pkg.Update_Row (
401: x_rowid => v_scho_rec.rowid,
402: x_person_id => v_scho_rec.person_id,
403: x_course_cd => v_scho_rec.course_cd,

Line 400: IGS_EN_STDNTPSHECSOP_Pkg.Update_Row (

396: p_hecs_payment_type := 'DEFERRED';
397: IF p_update_ind = 'Y' THEN
398: IF TRUNC(v_scho_rec.start_dt) <> TRUNC(p_effective_dt) THEN
399: -- end the current IGS_EN_STDNTPSHECSOP entry
400: IGS_EN_STDNTPSHECSOP_Pkg.Update_Row (
401: x_rowid => v_scho_rec.rowid,
402: x_person_id => v_scho_rec.person_id,
403: x_course_cd => v_scho_rec.course_cd,
404: x_start_dt => v_scho_rec.start_dt,

Line 425: IGS_EN_STDNTPSHECSOP_Pkg.Insert_Row (

421: );
422: -- Create a new hecs payment option entry for
423: -- the student IGS_PS_COURSE attempt
424: v_effective_dt := p_effective_dt;
425: IGS_EN_STDNTPSHECSOP_Pkg.Insert_Row (
426: x_rowid => lv_rowid,
427: x_person_id => v_scho_rec.person_id,
428: x_course_cd => v_scho_rec.course_cd,
429: x_start_dt => v_effective_dt,

Line 448: IGS_EN_STDNTPSHECSOP_Pkg.Update_Row (

444: x_diff_hecs_ind_update_comment => Null,
445: x_mode => 'R'
446: );
447: ELSE -- HECS option detail commenced on the effective dt
448: IGS_EN_STDNTPSHECSOP_Pkg.Update_Row (
449: x_rowid => v_scho_rec.rowid,
450: x_person_id => v_scho_rec.person_id,
451: x_course_cd => v_scho_rec.course_cd,
452: x_start_dt => v_scho_rec.start_dt,

Line 505: IGS_EN_STDNTPSHECSOP_Pkg.Update_Row (

501: p_hecs_payment_type := 'UPFRONT_D';
502: IF p_update_ind = 'Y' THEN
503: IF TRUNC(v_scho_rec.start_dt) <> TRUNC(p_effective_dt) THEN
504: -- End the current student IGS_PS_COURSE hecs option entry
505: IGS_EN_STDNTPSHECSOP_Pkg.Update_Row (
506: x_rowid => v_scho_rec.rowid,
507: x_person_id => v_scho_rec.person_id,
508: x_course_cd => v_scho_rec.course_cd,
509: x_start_dt => v_scho_rec.start_dt,

Line 530: IGS_EN_STDNTPSHECSOP_Pkg.Insert_Row (

526: );
527: -- Create a new hecs payment option entry for
528: -- the student IGS_PS_COURSE attempt
529: v_effective_dt := p_effective_dt;
530: IGS_EN_STDNTPSHECSOP_Pkg.Insert_Row (
531: x_rowid => lv_rowid,
532: x_person_id => v_scho_rec.person_id,
533: x_course_cd => v_scho_rec.course_cd,
534: x_start_dt => v_effective_dt,

Line 553: IGS_EN_STDNTPSHECSOP_Pkg.Update_Row (

549: x_diff_hecs_ind_update_comment => Null,
550: x_mode => 'R'
551: );
552: ELSE -- HECS option detail commenced on the effective dt
553: IGS_EN_STDNTPSHECSOP_Pkg.Update_Row (
554: x_rowid => v_scho_rec.rowid,
555: x_person_id => v_scho_rec.person_id,
556: x_course_cd => v_scho_rec.course_cd,
557: x_start_dt => v_scho_rec.start_dt,