APPS.IGF_AP_TODO_GRPS_PRC_PKG dependencies on IGF_AP_ISIR_MATCHED_ALL

Line 787: p_base_id igf_ap_isir_matched_all.base_id%type

783: || (reverse chronological order - newest change first)
784: */
785: -- Get the isir status for a student
786: CURSOR c_has_payment_isir(
787: p_base_id igf_ap_isir_matched_all.base_id%type
788: )IS
789: SELECT isir_id
790: FROM igf_ap_isir_matched_all
791: WHERE payment_isir='Y'

Line 790: FROM igf_ap_isir_matched_all

786: CURSOR c_has_payment_isir(
787: p_base_id igf_ap_isir_matched_all.base_id%type
788: )IS
789: SELECT isir_id
790: FROM igf_ap_isir_matched_all
791: WHERE payment_isir='Y'
792: AND base_id=p_base_id
793: AND system_record_type NOT IN ('INTERNAL','SIMULATED');
794:

Line 805: p_base_id igf_ap_isir_matched_all.base_id%type

801: WHERE active_profile='Y'
802: AND base_id=p_base_id;
803:
804: CURSOR c_has_isir(
805: p_base_id igf_ap_isir_matched_all.base_id%type
806: )IS
807: SELECT isir_id
808: FROM igf_ap_isir_matched_all
809: WHERE base_id=p_base_id

Line 808: FROM igf_ap_isir_matched_all

804: CURSOR c_has_isir(
805: p_base_id igf_ap_isir_matched_all.base_id%type
806: )IS
807: SELECT isir_id
808: FROM igf_ap_isir_matched_all
809: WHERE base_id=p_base_id
810: AND system_record_type IN ('ORIGINAL');
811:
812: -- Get the profile status for a student