APPS.IGF_AP_MK_PROF_ACT_PKG dependencies on IGF_AP_CSS_PROFILE

Line 114: FROM igf_ap_css_profile PROF

110: CURSOR c_chk_prof_rec_legacy(cp_base_id NUMBER,
111: cp_academic_year VARCHAR2 )
112: IS
113: SELECT PROF.row_id row_id
114: FROM igf_ap_css_profile PROF
115:
116: WHERE PROF.base_id = cp_base_id
117: AND PROF.academic_year = cp_academic_year
118: AND NVL(PROF.legacy_record_flag,'X') <> 'Y'

Line 135: CURSOR c_get_efc(cp_cssp_id igf_ap_css_profile.cssp_id%TYPE)

131: HAVING COUNT(person_number) > 1;
132:
133: l_get_dup_person c_get_dup_person%ROWTYPE;
134:
135: CURSOR c_get_efc(cp_cssp_id igf_ap_css_profile.cssp_id%TYPE)
136: IS
137: SELECT fm_inst_1_federal_efc
138: FROM igf_ap_css_fnar
139: WHERE cssp_id = cp_cssp_id;

Line 480: FROM igf_ap_css_profile_all PROF

476: PROF.p_tuit_fee_deduct_amt,
477: PROF.stu_lives_with_num,
478: PROF.stu_most_support_from_num,
479: PROF.location_computer_num
480: FROM igf_ap_css_profile_all PROF
481: WHERE PROF.base_id = cp_base_id
482: AND PROF.academic_year = cp_academic_year
483: AND PROF.css_id_number = cp_css_id_number
484: AND PROF.system_record_type = cp_rec_type;

Line 493: FROM igf_ap_css_profile PROF

489: CURSOR c_old_act_prof(cp_base_id NUMBER,
490: cp_rec_type VARCHAR2)
491: IS
492: SELECT PROF.row_id row_id
493: FROM igf_ap_css_profile PROF
494: WHERE PROF.base_id = cp_base_id
495: AND PROF.active_profile = 'Y'
496: AND PROF.system_record_type = cp_rec_type;
497:

Line 626: igf_ap_css_profile_pkg.update_row (

622: add_log_table_process(l_get_records.person_number,l_error,fnd_message.get);
623: l_error_flag := TRUE;
624: ELSE
625: -- update_profile_rec(l_get_prof_rec);
626: igf_ap_css_profile_pkg.update_row (
627: x_mode => 'R',
628: x_rowid => l_get_prof_rec.row_id,
629: x_cssp_id => l_get_prof_rec.cssp_id,
630: x_base_id => l_get_prof_rec.base_id,