APPS.IGF_GR_GEN_XML dependencies on IGF_AP_FA_BASE_REC_ALL

Line 134: FROM IGF_AP_FA_BASE_REC_ALL

130: CURSOR cur_chk_fa ( cp_base_id NUMBER,
131: cp_cal_type VARCHAR2,
132: cp_seq_number NUMBER) IS
133: SELECT base_id
134: FROM IGF_AP_FA_BASE_REC_ALL
135: WHERE base_id = cp_base_id
136: AND ci_cal_type = cp_cal_type
137: AND ci_sequence_number = cp_seq_number;
138: chk_fa_rec cur_chk_fa%ROWTYPE;

Line 157: FUNCTION per_in_fa ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,

153: igs_ge_msg_stack.add;
154: app_exception.raise_exception;
155: END check_fa_rec;
156:
157: FUNCTION per_in_fa ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE,
158: p_ci_cal_type VARCHAR2,
159: p_ci_sequence_number NUMBER,
160: p_base_id OUT NOCOPY NUMBER
161: )

Line 174: CURSOR cur_get_pers_num ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS

170: Who When What
171: (reverse chronological order - newest change first)
172: ***************************************************************/
173:
174: CURSOR cur_get_pers_num ( p_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
175: SELECT person_number
176: FROM IGS_PE_PERSON_BASE_V
177: WHERE person_id = p_person_id;
178: get_pers_num_rec cur_get_pers_num%ROWTYPE;

Line 182: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS

178: get_pers_num_rec cur_get_pers_num%ROWTYPE;
179:
180: CURSOR cur_get_base ( p_cal_type igs_ca_inst_all.cal_type%TYPE,
181: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
182: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
183: SELECT base_id
184: FROM IGF_AP_FA_BASE_REC_ALL
185: WHERE person_id = p_person_id
186: AND ci_cal_type = p_cal_type

Line 184: FROM IGF_AP_FA_BASE_REC_ALL

180: CURSOR cur_get_base ( p_cal_type igs_ca_inst_all.cal_type%TYPE,
181: p_sequence_number igs_ca_inst_all.sequence_number%TYPE,
182: p_person_id igf_ap_fa_base_rec_all.person_id%TYPE) IS
183: SELECT base_id
184: FROM IGF_AP_FA_BASE_REC_ALL
185: WHERE person_id = p_person_id
186: AND ci_cal_type = p_cal_type
187: AND ci_sequence_number = p_sequence_number;
188:

Line 367: CURSOR cur_fa_base ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS

363: AND rfms.rep_entity_id_txt = cp_report_entity_id
364: AND rfms.atd_entity_id_txt = cp_attend_entity_id;
365:
366: -- To check fa base record exists or not.
367: CURSOR cur_fa_base ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
368: SELECT fabase.base_id
369: FROM IGF_AP_FA_BASE_REC_ALL fabase
370: WHERE fabase.base_id = cp_base_id;
371:

Line 369: FROM IGF_AP_FA_BASE_REC_ALL fabase

365:
366: -- To check fa base record exists or not.
367: CURSOR cur_fa_base ( cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE) IS
368: SELECT fabase.base_id
369: FROM IGF_AP_FA_BASE_REC_ALL fabase
370: WHERE fabase.base_id = cp_base_id;
371:
372: -- To check pell origination records exists or not with given person.
373: CURSOR cur_person_number ( cp_cal_type igs_ca_inst.cal_type%TYPE,

Line 375: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS

371:
372: -- To check pell origination records exists or not with given person.
373: CURSOR cur_person_number ( cp_cal_type igs_ca_inst.cal_type%TYPE,
374: cp_sequence_number igs_ca_inst.sequence_number%TYPE,
375: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE ) IS
376: SELECT 'x'
377: FROM IGF_GR_RFMS rfms
378: WHERE rfms.ci_cal_type = cp_cal_type
379: AND rfms.ci_sequence_number = cp_sequence_number