APPS.IGF_SL_DL_LI_IMP_PKG dependencies on IGF_AP_FA_BASE_REC

Line 128: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;

124: l_award_year_status VARCHAR2(80);
125: g_request_id NUMBER := NULL;
126: l_b_person_id NUMBER ;
127: g_error_string VARCHAR2(200);
128: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
129: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
130:
131: PROCEDURE log_input_params( p_batch_num IN igf_aw_li_coa_ints.batch_num%TYPE ,
132: p_alternate_code IN igs_ca_inst.alternate_code%TYPE ,

Line 129: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;

125: g_request_id NUMBER := NULL;
126: l_b_person_id NUMBER ;
127: g_error_string VARCHAR2(200);
128: l_cal_type igf_ap_fa_base_rec_all.ci_cal_type%TYPE ;
129: l_seq_number igf_ap_fa_base_rec_all.ci_sequence_number%TYPE;
130:
131: PROCEDURE log_input_params( p_batch_num IN igf_aw_li_coa_ints.batch_num%TYPE ,
132: p_alternate_code IN igs_ca_inst.alternate_code%TYPE ,
133: p_delete_flag IN VARCHAR2)

Line 1095: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;

1091: l_valid BOOLEAN;
1092: indx NUMBER := 0;
1093: l_error VARCHAR2(20);
1094: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
1095: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
1096:
1097: -- Get the details of
1098: CURSOR c_accepted_amt(p_award_id NUMBER)
1099: IS

Line 1936: igf_ap_fa_base_rec fabase

1932: fabase.person_id student_id
1933: FROM igf_sl_loans loans,
1934: igf_sl_lor lor,
1935: igf_aw_award awd,
1936: igf_ap_fa_base_rec fabase
1937: WHERE fabase.base_id = awd.base_id
1938: AND loans.award_id = awd.award_id
1939: AND loans.loan_id = lor.loan_id
1940: AND loans.loan_id = p_loan_id;

Line 1954: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir

1950:
1951: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
1952: IS
1953: SELECT isir.dependency_status
1954: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir
1955: WHERE isir.base_id = fabase.base_id
1956: AND isir.payment_isir = 'Y'
1957: AND isir.system_record_type = 'ORIGINAL'
1958: AND fabase.person_id = cp_person_id;

Line 2373: igf_ap_fa_base_rec fabase

2369: fabase.person_id student_id
2370: FROM igf_sl_loans loans,
2371: igf_sl_lor lor,
2372: igf_aw_award awd,
2373: igf_ap_fa_base_rec fabase
2374: WHERE fabase.base_id = awd.base_id
2375: AND loans.award_id = awd.award_id
2376: AND loans.loan_id = lor.loan_id
2377: AND loans.loan_id = p_loan_id;

Line 2390: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir

2386:
2387: CURSOR cur_isir_depend_status (cp_person_id NUMBER)
2388: IS
2389: SELECT isir.dependency_status
2390: FROM igf_ap_fa_base_rec fabase,igf_ap_isir_matched isir
2391: WHERE isir.base_id = fabase.base_id
2392: AND isir.payment_isir = 'Y'
2393: AND isir.system_record_type = 'ORIGINAL'
2394: AND fabase.person_id = cp_person_id;

Line 3131: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;

3127: l_batch_valid VARCHAR2(1) ;
3128: l_processing VARCHAR2(80);
3129: l_person_number VARCHAR2(80);
3130: lv_person_id igs_pe_hz_parties.party_id%TYPE := NULL;
3131: lv_base_id igf_ap_fa_base_rec_all.base_id%TYPE := NULL;
3132: l_valid_for_dml VARCHAR2(2);
3133: l_error_flag BOOLEAN := FALSE;
3134: l_award_id igf_aw_award_all.award_id%TYPE;
3135: p_status BOOLEAN;