APPS.IGS_FI_PRC_ACCT_PKG dependencies on IGS_FI_FTCI_ACCTS

Line 382: FROM igs_fi_ftci_accts

378: cp_v_fee_cal_type VARCHAR2,
379: cp_n_sequence_number NUMBER)
380: IS
381: SELECT *
382: FROM igs_fi_ftci_accts
383: WHERE fee_type = cp_v_fee_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;

Line 398: l_v_natural_account_segment igs_fi_ftci_accts.natural_account_segment%TYPE;

394: l_cur_ftci_accts cur_ftci_accts%ROWTYPE;
395: l_n_rec_exists NUMBER :=0;
396: l_b_flag BOOLEAN := FALSE;
397: l_b_rec_matchs BOOLEAN := FALSE;
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;

Line 399: l_v_rev_account_cd igs_fi_ftci_accts.rev_account_cd%TYPE;

395: l_n_rec_exists NUMBER :=0;
396: l_b_flag BOOLEAN := FALSE;
397: l_b_rec_matchs BOOLEAN := FALSE;
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

Line 764: l_v_nat_acct_seg igs_fi_ftci_accts.natural_account_segment%TYPE;

760: l_coa_id gl_sets_of_books.chart_of_accounts_id%TYPE;
761: l_entity_no NUMBER;
762: l_b_err_type1 BOOLEAN := FALSE;
763:
764: l_v_nat_acct_seg igs_fi_ftci_accts.natural_account_segment%TYPE;
765: l_v_account_cd igs_fi_acc.account_cd%TYPE;
766: l_n_err_type NUMBER;
767: l_v_err_msg fnd_new_messages.message_name%TYPE;
768: l_b_nat_rec BOOLEAN;