APPS.IGF_AW_PACKAGING dependencies on IGF_AP_FA_CON_V

Line 2176: FROM igf_ap_fa_con_v faconv

2172:
2173: -- Get the Person Number and SSN of the student, used to log the messages in the log file
2174: CURSOR c_person_number IS
2175: SELECT person_number, ssn, person_id
2176: FROM igf_ap_fa_con_v faconv
2177: WHERE faconv.base_id = l_base_id;
2178:
2179: l_person_number c_person_number%ROWTYPE;
2180:

Line 7668: CURSOR c_person_number( x_base_id igf_ap_fa_con_v.base_id%TYPE ) IS

7664:
7665: l_awds std_awards;
7666:
7667: -- Get the person Number for log
7668: CURSOR c_person_number( x_base_id igf_ap_fa_con_v.base_id%TYPE ) IS
7669: SELECT pe.party_number person_number, fa.packaging_status
7670: FROM igf_ap_fa_base_rec_all fa,
7671: hz_parties pe
7672: WHERE fa.base_id = x_base_id

Line 7715: l_pers_num igf_ap_fa_con_v.person_number%TYPE;

7711: l_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
7712: l_aid NUMBER(12,2);
7713: l_accepted_amt NUMBER(12,2);
7714: l_seq_no NUMBER;
7715: l_pers_num igf_ap_fa_con_v.person_number%TYPE;
7716: lv_rowid VARCHAR2(30);
7717: l_sl_number NUMBER;
7718: l_chk NUMBER;
7719: l_ret_status VARCHAR2(3);