APPS.IGF_GR_GEN dependencies on IGF_GR_REPORT_PELL

Line 22: -- from igf_gr_report_pell table rather igf_ap_fa_setup table.

18: -- ugummall 03-NOV-2003 Bug 3102439. FA 126 - Multiple FA Offices.
19: -- 1. Added two extra parameters p_ci_cal_type and p_ci_sequence_number
20: -- to get_pell_header
21: -- 2. Removed cursor c_ope_id and added cur_get_ope_id to get ope id
22: -- from igf_gr_report_pell table rather igf_ap_fa_setup table.
23: -----------------------------------------------------------------------------------
24: -- sjadhav 26-Jun-2003 Bug 2938258
25: -- Pell and Disb records batch id (rfmb_id) set to NULL
26: -- when record moved to ready to send status

Line 626: -- Modified this cursor c_ope_id to get ope id from igf_gr_report_pell

622: l_header VARCHAR2(1000);
623: l_rowid VARCHAR2(30);
624: ln_data_rec_len NUMBER;
625:
626: -- Modified this cursor c_ope_id to get ope id from igf_gr_report_pell
627: -- table instead of igf_ap_fa_setup w.r.t FA 126
628: CURSOR cur_get_ope_id( cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,
629: cp_ci_seq_num igf_gr_report_pell.ci_sequence_number%TYPE,
630: cp_rep_pell_id igf_gr_report_pell.reporting_pell_cd%TYPE

Line 628: CURSOR cur_get_ope_id( cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,

624: ln_data_rec_len NUMBER;
625:
626: -- Modified this cursor c_ope_id to get ope id from igf_gr_report_pell
627: -- table instead of igf_ap_fa_setup w.r.t FA 126
628: CURSOR cur_get_ope_id( cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,
629: cp_ci_seq_num igf_gr_report_pell.ci_sequence_number%TYPE,
630: cp_rep_pell_id igf_gr_report_pell.reporting_pell_cd%TYPE
631: )
632: IS

Line 629: cp_ci_seq_num igf_gr_report_pell.ci_sequence_number%TYPE,

625:
626: -- Modified this cursor c_ope_id to get ope id from igf_gr_report_pell
627: -- table instead of igf_ap_fa_setup w.r.t FA 126
628: CURSOR cur_get_ope_id( cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,
629: cp_ci_seq_num igf_gr_report_pell.ci_sequence_number%TYPE,
630: cp_rep_pell_id igf_gr_report_pell.reporting_pell_cd%TYPE
631: )
632: IS
633: SELECT ope_cd

Line 630: cp_rep_pell_id igf_gr_report_pell.reporting_pell_cd%TYPE

626: -- Modified this cursor c_ope_id to get ope id from igf_gr_report_pell
627: -- table instead of igf_ap_fa_setup w.r.t FA 126
628: CURSOR cur_get_ope_id( cp_ci_cal_type igf_gr_report_pell.ci_cal_type%TYPE,
629: cp_ci_seq_num igf_gr_report_pell.ci_sequence_number%TYPE,
630: cp_rep_pell_id igf_gr_report_pell.reporting_pell_cd%TYPE
631: )
632: IS
633: SELECT ope_cd
634: FROM igf_gr_report_pell rpell

Line 634: FROM igf_gr_report_pell rpell

630: cp_rep_pell_id igf_gr_report_pell.reporting_pell_cd%TYPE
631: )
632: IS
633: SELECT ope_cd
634: FROM igf_gr_report_pell rpell
635: WHERE rpell.ci_cal_type = cp_ci_cal_type
636: AND rpell.ci_sequence_number = cp_ci_seq_num
637: AND rpell.reporting_pell_cd = cp_rep_pell_id;
638:

Line 2994: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)

2990:
2991:
2992: FUNCTION get_rep_pell_from_ope(p_cal_type igs_ca_inst_all.cal_type%TYPE,
2993: p_seq_num igs_ca_inst_all.sequence_number%TYPE,
2994: p_ope_cd igf_gr_report_pell.ope_cd%TYPE)
2995: RETURN VARCHAR2
2996: AS
2997:
2998: CURSOR c_get_rep_pell_from_ope(cp_cal_type VARCHAR2,cp_seq_num NUMBER,cp_ope_cd VARCHAR2)

Line 3002: igf_gr_report_pell grp

2998: CURSOR c_get_rep_pell_from_ope(cp_cal_type VARCHAR2,cp_seq_num NUMBER,cp_ope_cd VARCHAR2)
2999: IS
3000: SELECT grp.reporting_pell_cd
3001: FROM
3002: igf_gr_report_pell grp
3003: WHERE
3004: grp.ci_cal_type = cp_cal_type AND
3005: grp.ci_sequence_number = cp_seq_num AND
3006: grp.ope_cd = cp_ope_cd;

Line 3036: igf_gr_report_pell grp

3032: IS
3033: SELECT grp.reporting_pell_cd
3034: FROM
3035: igf_gr_attend_pell gap,
3036: igf_gr_report_pell grp
3037: WHERE
3038: gap.ci_cal_type = cp_cal_type AND
3039: gap.ci_sequence_number = cp_seq_num AND
3040: gap.attending_pell_cd = cp_att_pell AND