APPS.IGS_FI_1098T_EXTRACT_DATA dependencies on IGS_FI_1098T_LPS

Line 376: FROM igs_fi_1098t_lps lps,

372: CURSOR cur_prior_lps(cp_v_load_cal_type igs_ca_inst.cal_type%TYPE,
373: cp_n_load_ci_seq_num igs_ca_inst.sequence_number%TYPE,
374: cp_d_end_date igs_fi_1098t_setup.end_date%TYPE) IS
375: SELECT stp.tax_year_name
376: FROM igs_fi_1098t_lps lps,
377: igs_fi_1098t_setup stp
378: WHERE lps.cal_type = cp_v_load_cal_type
379: AND lps.sequence_number = cp_n_load_ci_seq_num
380: AND lps.tax_year_name = stp.tax_year_name

Line 636: FROM igs_fi_1098t_lps

632: AND closed_ind = cp_v_closed_ind;
633:
634: CURSOR cur_val_one_lps(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS
635: SELECT 'x'
636: FROM igs_fi_1098t_lps
637: WHERE tax_year_name = cp_v_tax_year_name;
638:
639: CURSOR cur_val_one_ft(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS
640: SELECT 'x'

Line 1200: FROM igs_fi_1098t_lps

1196: CURSOR cur_next_acad_flag(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,
1197: cp_v_load_cal_type igs_ca_inst.cal_type%TYPE,
1198: cp_n_load_ci_seq igs_ca_inst.sequence_number%TYPE) IS
1199: SELECT 'x'
1200: FROM igs_fi_1098t_lps
1201: WHERE tax_year_name = cp_v_tax_year_name
1202: AND cal_type = cp_v_load_cal_type
1203: AND sequence_number = cp_n_load_ci_seq
1204: AND next_acad_flag = 'Y';

Line 1224: l_v_next_acad_flag igs_fi_1098t_lps.next_acad_flag%TYPE;

1220: AND TRUNC(stp.end_date) < TRUNC(cp_d_start_date)
1221: AND TRUNC(invoice_creation_date) < TRUNC(cp_d_start_date);
1222:
1223: l_b_prc_chg BOOLEAN;
1224: l_v_next_acad_flag igs_fi_1098t_lps.next_acad_flag%TYPE;
1225: l_b_non_zero_credits_flag BOOLEAN;
1226: l_v_message_name VARCHAR2(2000);
1227: l_var VARCHAR2(1);
1228: l_b_bool BOOLEAN;

Line 1844: FROM igs_fi_1098t_lps

1840: ***************************************************************** */
1841: CURSOR cur_lps(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS
1842: SELECT cal_type,
1843: sequence_number
1844: FROM igs_fi_1098t_lps
1845: WHERE tax_year_name = cp_v_tax_year_name
1846: AND half_time_flag = 'Y';
1847:
1848: CURSOR cur_ats(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE,

Line 1912: FROM igs_fi_1098t_lps

1908:
1909: CURSOR cur_lps(cp_v_tax_year_name igs_fi_1098t_setup.tax_year_name%TYPE) IS
1910: SELECT cal_type,
1911: sequence_number
1912: FROM igs_fi_1098t_lps
1913: WHERE tax_year_name = cp_v_tax_year_name
1914: AND grad_flag = 'Y';
1915:
1916: CURSOR cur_load_teach(cp_v_cal_type igs_ca_inst.cal_type%TYPE,