APPS.IGF_GR_LI_IMPORT dependencies on IGF_GR_RFMS_ALL

Line 566: p_origination_id igf_gr_rfms_all.origination_id%TYPE,

562: END update_fa_base_data;
563:
564:
565: FUNCTION delete_existing_pell_rec(
566: p_origination_id igf_gr_rfms_all.origination_id%TYPE,
567: p_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,
568: p_seq_number igf_gr_rfms_all.ci_sequence_number%TYPE
569: ) RETURN VARCHAR2 AS
570:

Line 567: p_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,

563:
564:
565: FUNCTION delete_existing_pell_rec(
566: p_origination_id igf_gr_rfms_all.origination_id%TYPE,
567: p_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,
568: p_seq_number igf_gr_rfms_all.ci_sequence_number%TYPE
569: ) RETURN VARCHAR2 AS
570:
571: /*

Line 568: p_seq_number igf_gr_rfms_all.ci_sequence_number%TYPE

564:
565: FUNCTION delete_existing_pell_rec(
566: p_origination_id igf_gr_rfms_all.origination_id%TYPE,
567: p_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,
568: p_seq_number igf_gr_rfms_all.ci_sequence_number%TYPE
569: ) RETURN VARCHAR2 AS
570:
571: /*
572: || Created By : brajendr

Line 583: cp_origination_id igf_gr_rfms_all.origination_id%TYPE,

579: */
580:
581: -- Check whether is there any pell origination record present for the context information
582: CURSOR c_chk_pell_orig(
583: cp_origination_id igf_gr_rfms_all.origination_id%TYPE,
584: cp_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,
585: cp_seq_number igf_gr_rfms_all.ci_sequence_number%TYPE
586: ) IS
587: SELECT ROWID row_id, rfms.rfmb_id

Line 584: cp_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,

580:
581: -- Check whether is there any pell origination record present for the context information
582: CURSOR c_chk_pell_orig(
583: cp_origination_id igf_gr_rfms_all.origination_id%TYPE,
584: cp_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,
585: cp_seq_number igf_gr_rfms_all.ci_sequence_number%TYPE
586: ) IS
587: SELECT ROWID row_id, rfms.rfmb_id
588: FROM igf_gr_rfms_all rfms

Line 585: cp_seq_number igf_gr_rfms_all.ci_sequence_number%TYPE

581: -- Check whether is there any pell origination record present for the context information
582: CURSOR c_chk_pell_orig(
583: cp_origination_id igf_gr_rfms_all.origination_id%TYPE,
584: cp_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,
585: cp_seq_number igf_gr_rfms_all.ci_sequence_number%TYPE
586: ) IS
587: SELECT ROWID row_id, rfms.rfmb_id
588: FROM igf_gr_rfms_all rfms
589: WHERE rfms.origination_id = cp_origination_id

Line 588: FROM igf_gr_rfms_all rfms

584: cp_cal_type igf_gr_rfms_all.ci_cal_type%TYPE,
585: cp_seq_number igf_gr_rfms_all.ci_sequence_number%TYPE
586: ) IS
587: SELECT ROWID row_id, rfms.rfmb_id
588: FROM igf_gr_rfms_all rfms
589: WHERE rfms.origination_id = cp_origination_id
590: AND rfms.ci_cal_type = cp_cal_type
591: AND rfms.ci_sequence_number = cp_seq_number
592: AND NVL(rfms.legacy_record_flag,'N') = 'Y';

Line 598: cp_origination_id igf_gr_rfms_all.origination_id%TYPE

594: lc_chk_pell_orig c_chk_pell_orig%ROWTYPE;
595:
596: -- Get the details of
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;

Line 1459: FROM igf_gr_rfms_all rfms

1455: CURSOR c_chk_rfms_awd(
1456: cp_award_id igf_aw_award_all.award_id%TYPE
1457: ) IS
1458: SELECT rfms.origination_id
1459: FROM igf_gr_rfms_all rfms
1460: WHERE rfms.award_id = cp_award_id;
1461:
1462: lc_chk_rfms_awd c_chk_rfms_awd%ROWTYPE;
1463:

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: