APPS.IGS_RE_VAL_CA dependencies on IGS_AD_APPL

Line 526: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

522: cst_readmit CONSTANT VARCHAR2(10) := 'RE-ADMIT';
523:
524: cst_research CONSTANT VARCHAR2(10) := 'RESEARCH';
525:
526: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
527:
528: v_test VARCHAR2(1);
529:
530: v_message_name VARCHAR2(30);

Line 538: FROM IGS_AD_APPL aa

534: IS
535:
536: SELECT aa.s_admission_process_type
537:
538: FROM IGS_AD_APPL aa
539:
540: WHERE aa.person_id = p_person_id AND
541:
542: aa.admission_appl_number = p_acai_admission_appl_number;

Line 570: FROM IGS_AD_APPL aa,

566: IS
567:
568: SELECT 'x'
569:
570: FROM IGS_AD_APPL aa,
571:
572: IGS_AD_PRCS_CAT_STEP apcs
573:
574: WHERE aa.person_id = p_person_id AND

Line 1373: FROM IGS_AD_APPL aa,

1369: CURSOR c_apcs IS
1370:
1371: SELECT apcs.mandatory_step_ind
1372:
1373: FROM IGS_AD_APPL aa,
1374:
1375: IGS_AD_PRCS_CAT_STEP apcs
1376:
1377: WHERE aa.person_id = p_person_id AND