DBA Data[Home] [Help]

APPS.IGS_FI_PRC_ACCT_PKG dependencies on IGS_EN_ATD_MODE_ALL

Line 388: CURSOR cur_get_att_mode( p_att_mode igs_en_atd_mode_all.attendance_mode%TYPE)

384: AND fee_cal_type = cp_v_fee_cal_type
385: AND fee_ci_sequence_number = cp_n_sequence_number
386: ORDER BY order_sequence;
387:
388: CURSOR cur_get_att_mode( p_att_mode igs_en_atd_mode_all.attendance_mode%TYPE)
389: IS
390: SELECT am.govt_attendance_mode
391: FROM igs_en_atd_mode_all am
392: WHERE am.attendance_mode=p_att_mode;

Line 391: FROM igs_en_atd_mode_all am

387:
388: CURSOR cur_get_att_mode( p_att_mode igs_en_atd_mode_all.attendance_mode%TYPE)
389: IS
390: SELECT am.govt_attendance_mode
391: FROM igs_en_atd_mode_all am
392: WHERE am.attendance_mode=p_att_mode;
393:
394: l_cur_ftci_accts cur_ftci_accts%ROWTYPE;
395: l_n_rec_exists NUMBER :=0;

Line 402: l_v_att_mode igs_en_atd_mode_all.attendance_mode%TYPE;

398: l_v_natural_account_segment igs_fi_ftci_accts.natural_account_segment%TYPE;
399: l_v_rev_account_cd igs_fi_ftci_accts.rev_account_cd%TYPE;
400: cst_nominated CONSTANT igs_lookups_view.lookup_code%TYPE := 'NOMINATED';
401: cst_derived CONSTANT igs_lookups_view.lookup_code%TYPE := 'DERIVED';
402: l_v_att_mode igs_en_atd_mode_all.attendance_mode%TYPE;
403: BEGIN
404:
405: FOR l_rec_ftci_accts IN cur_ftci_accts(p_v_fee_type,p_v_fee_cal_type,p_n_fee_ci_seq_num) LOOP
406: l_b_flag := TRUE;