APPS.IGF_AP_INST_APP dependencies on IGF_AP_APPL_SETUP_ALL

Line 602: cp_application_code igf_ap_appl_setup_all.application_name%TYPE

598:
599:
600: -- Get Institutional application name
601: CURSOR c_application_name(
602: cp_application_code igf_ap_appl_setup_all.application_name%TYPE
603: ) IS
604: SELECT APPLICATION_NAME
605: FROM IGF_AP_APPL_SETUP_ALL
606: WHERE APPLICATION_CODE = cp_application_code

Line 605: FROM IGF_AP_APPL_SETUP_ALL

601: CURSOR c_application_name(
602: cp_application_code igf_ap_appl_setup_all.application_name%TYPE
603: ) IS
604: SELECT APPLICATION_NAME
605: FROM IGF_AP_APPL_SETUP_ALL
606: WHERE APPLICATION_CODE = cp_application_code
607: AND ROWNUM = 1;
608: l_application_name igf_ap_appl_setup_all.application_name%TYPE;
609:

Line 608: l_application_name igf_ap_appl_setup_all.application_name%TYPE;

604: SELECT APPLICATION_NAME
605: FROM IGF_AP_APPL_SETUP_ALL
606: WHERE APPLICATION_CODE = cp_application_code
607: AND ROWNUM = 1;
608: l_application_name igf_ap_appl_setup_all.application_name%TYPE;
609:
610: l_seq_val NUMBER;
611:
612: l_wf_event_t WF_EVENT_T;