APPS.IGF_AP_TODO_GRPS_PRC_PKG dependencies on IGF_AP_CSS_PROFILE_ALL

Line 797: p_base_id igf_ap_css_profile_all.base_id%type

793: AND system_record_type NOT IN ('INTERNAL','SIMULATED');
794:
795: -- Get the profile status for a student
796: CURSOR c_has_active_profile(
797: p_base_id igf_ap_css_profile_all.base_id%type
798: )IS
799: SELECT cssp_id
800: FROM igf_ap_css_profile_all
801: WHERE active_profile='Y'

Line 800: FROM igf_ap_css_profile_all

796: CURSOR c_has_active_profile(
797: p_base_id igf_ap_css_profile_all.base_id%type
798: )IS
799: SELECT cssp_id
800: FROM igf_ap_css_profile_all
801: WHERE active_profile='Y'
802: AND base_id=p_base_id;
803:
804: CURSOR c_has_isir(

Line 814: p_base_id igf_ap_css_profile_all.base_id%type

810: AND system_record_type IN ('ORIGINAL');
811:
812: -- Get the profile status for a student
813: CURSOR c_has_profile(
814: p_base_id igf_ap_css_profile_all.base_id%type
815: )IS
816: SELECT cssp_id
817: FROM igf_ap_css_profile_all
818: WHERE base_id=p_base_id;

Line 817: FROM igf_ap_css_profile_all

813: CURSOR c_has_profile(
814: p_base_id igf_ap_css_profile_all.base_id%type
815: )IS
816: SELECT cssp_id
817: FROM igf_ap_css_profile_all
818: WHERE base_id=p_base_id;
819: lc_has_payment_isir c_has_payment_isir%ROWTYPE;
820: lc_has_isir c_has_isir%ROWTYPE;
821: lc_has_profile c_has_profile%ROWTYPE;