APPS.IGF_GR_LI_IMPORT dependencies on IGF_GR_RFMS_DISB_ALL

Line 601: FROM igf_gr_rfms_disb_all pdb

597: CURSOR c_get_pell_disb(
598: cp_origination_id igf_gr_rfms_all.origination_id%TYPE
599: ) IS
600: SELECT ROWID row_id, pdb.rfmd_id, pdb.rfmb_id
601: FROM igf_gr_rfms_disb_all pdb
602: WHERE pdb.origination_id = cp_origination_id;
603:
604: l_return_val VARCHAR2(1) := 'E';
605: l_debug_str fnd_log_messages.message_text%TYPE := 'IGFGR10B.pls Procedure delete_existing_pell_rec :: ';

Line 1471: FROM igf_gr_rfms_all porig, igf_gr_rfms_disb_all pdisb

1467: SELECT ad.disb_num, ad.disb_date, ad.disb_accepted_amt
1468: FROM igf_aw_awd_disb_all ad
1469: WHERE ad.award_id = cp_award_id
1470: AND NOT EXISTS ( SELECT pdisb.disb_ref_num
1471: FROM igf_gr_rfms_all porig, igf_gr_rfms_disb_all pdisb
1472: WHERE porig.origination_id = pdisb.origination_id
1473: AND ad.award_id = porig.award_id
1474: AND ad.disb_num = pdisb.disb_ref_num);
1475: