APPS.IGS_EN_NSC_PKG dependencies on IGS_EN_NSC_OPTIONS

Line 267: FROM igs_en_nsc_options

263:
264:
265: CURSOR c_grad_type IS
266: SELECT opt_val
267: FROM igs_en_nsc_options
268: WHERE opt_type = 'DATE_GRAD';
269:
270:
271: --First get a list of active programs which are attempted by a student

Line 384: FROM igs_en_nsc_options

380: WHERE perv.person_id=cp_person_id
381: AND information_type = 'PE_STAT_RES_STATUS'
382: AND perv.pei_information1 NOT IN
383: (SELECT opt_val
384: FROM igs_en_nsc_options
385: WHERE opt_type = 'NC_STAT_CD'
386: )
387: AND EXISTS
388: (SELECT 'X'

Line 1449: igs_en_nsc_options eno

1445: -- Check for previous last name
1446: CURSOR c_prev_last_name IS
1447: SELECT ppa.surname
1448: FROM igs_pe_person_alias ppa,
1449: igs_en_nsc_options eno
1450: WHERE ppa.person_id = p_student_data.student_id
1451: AND ppa.alias_type = eno.opt_val
1452: AND eno.opt_type = 'LAST_NAME'
1453: AND ppa.start_dt <= SYSDATE

Line 1469: FROM igs_en_nsc_options

1465: FROM igs_pe_person_addr
1466: WHERE person_id = p_student_data.student_id
1467: AND addr_type
1468: IN (SELECT opt_val
1469: FROM igs_en_nsc_options
1470: WHERE opt_type = 'ADDR_TYPE')
1471: AND (status = 'A'
1472: AND SYSDATE BETWEEN NVL(start_dt,SYSDATE) AND NVL(end_dt,SYSDATE+1))
1473: ORDER BY start_dt DESC;

Line 1478: FROM igs_pe_priv_level pl,igs_en_nsc_options op

1474:
1475:
1476: CURSOR c_priv_block IS
1477: SELECT 'Y'
1478: FROM igs_pe_priv_level pl,igs_en_nsc_options op
1479: WHERE pl.person_id = p_student_data.student_id
1480: AND to_char(pl.data_group_id)=op.opt_val
1481: AND op.opt_type = 'BLK_IND'
1482: AND pl.start_date <= SYSDATE

Line 1779: FROM igs_en_nsc_options

1775: l_career_profile VARCHAR2(1);
1776:
1777: CURSOR c_enr_status (l_status VARCHAR2) IS
1778: SELECT substr(opt_type,10,1)
1779: FROM igs_en_nsc_options
1780: WHERE opt_val = l_status
1781: AND opt_type IN
1782: ('ENR_STAT_F','ENR_STAT_H','ENR_STAT_L');
1783:

Line 1851: FROM igs_en_nsc_options

1847: /* To check whether all the programs of the student are of type GRADUATE i.e required for Graduate Level Indicator Field */
1848:
1849: CURSOR c_grad_lvl(p_course_cd VARCHAR2, p_version_number NUMBER) IS
1850: SELECT 'x'
1851: FROM igs_en_nsc_options
1852: WHERE opt_type='GR_LVL_IND'
1853: AND opt_val IN (SELECT course_type_group_cd FROM igs_ps_type
1854: WHERE course_type = ( SELECT course_type
1855: FROM igs_ps_ver_all

Line 1869: FROM igs_en_nsc_options

1865: /* Checking whether the student is enrolled in any correspondence programs */
1866:
1867: CURSOR c_corresp_prg(p_course_cd VARCHAR2, p_version_number NUMBER) IS
1868: SELECT 'x'
1869: FROM igs_en_nsc_options
1870: WHERE opt_type='CO_PRG_TG'
1871: AND opt_val IN (SELECT course_type_group_cd FROM igs_ps_type
1872: WHERE course_type = (SELECT course_type
1873: FROM igs_ps_ver_all

Line 2663: igs_En_nsc_options where opt_type = 'ENR_STAT_'||p_old_status)

2659: FROM igs_en_atd_type_load
2660: WHERE
2661: cal_type = p_load_cal_type
2662: AND attendance_type in (select opt_val from
2663: igs_En_nsc_options where opt_type = 'ENR_STAT_'||p_old_status)
2664: order by lower_enr_load_range;
2665:
2666: --List of all courses for the given load term
2667: CURSOR c_all_units IS