APPS.IGF_AP_PROFILE_MATCHING_PKG dependencies on IGF_AP_CSS_PROFILE_ALL

Line 242: FROM igf_ap_css_profile_all css

238: */
239: -- cursor to update the active_profile of igf_ap_css_profile to 'N'
240: CURSOR cur_css_profile(x_base_id igf_ap_fa_base_rec.base_id%TYPE) IS
241: SELECT ROWID row_id, css.*
242: FROM igf_ap_css_profile_all css
243: WHERE base_id = x_base_id FOR UPDATE NOWAIT ;
244: BEGIN
245: -- Cursor for updating the active_profile of all the old profile records of the student to 'n'
246: FOR css_profile_data IN cur_css_profile(cp_base_id) LOOP

Line 5052: l_base_id igf_ap_css_profile_all.base_id%TYPE;

5048:
5049: rec_check_duplicate_profile cur_check_duplicate_profile%ROWTYPE;
5050: rec_profile_records cur_profile_records%ROWTYPE;
5051: rec_get_base_id cur_get_base_id%ROWTYPE;
5052: l_base_id igf_ap_css_profile_all.base_id%TYPE;
5053: lv_rowid NUMBER;
5054: pn_cssp_id NUMBER;
5055:
5056: BEGIN