APPS.IGS_AD_VAL_APCS dependencies on IGS_LOOKUPS_VIEW

Line 15: IGS_LOOKUPS_view.step_order_applicable_ind%TYPE;

11: -- Validate the admission_process_cat_step.mandatory_step_ind
12: DECLARE
13: cst_no CONSTANT CHAR := 'N';
14: v_step_order_applicable_ind
15: IGS_LOOKUPS_view.step_order_applicable_ind%TYPE;
16: CURSOR c_apcs (
17: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
18: SELECT sasgt.step_order_applicable_ind
19: FROM IGS_LOOKUPS_view sasgt,

Line 19: FROM IGS_LOOKUPS_view sasgt,

15: IGS_LOOKUPS_view.step_order_applicable_ind%TYPE;
16: CURSOR c_apcs (
17: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
18: SELECT sasgt.step_order_applicable_ind
19: FROM IGS_LOOKUPS_view sasgt,
20: IGS_LOOKUPS_view sast
21: WHERE sasgt.lookup_code = sast.step_group_type AND
22: sast.lookup_code = cp_s_admission_step_type AND
23: sast.lookup_type = 'ADMISSION_STEP_TYPE' AND --2402377

Line 20: IGS_LOOKUPS_view sast

16: CURSOR c_apcs (
17: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
18: SELECT sasgt.step_order_applicable_ind
19: FROM IGS_LOOKUPS_view sasgt,
20: IGS_LOOKUPS_view sast
21: WHERE sasgt.lookup_code = sast.step_group_type AND
22: sast.lookup_code = cp_s_admission_step_type AND
23: sast.lookup_type = 'ADMISSION_STEP_TYPE' AND --2402377
24: sasgt.lookup_Type = 'ADM_STEP_GROUP_TYPE'; --2402377

Line 61: v_step_order_num IGS_LOOKUPS_view.step_type_restriction_num_ind%TYPE;

57: -- Validate the IGS_AD_PRCS_CAT_STEP.step_order_num
58: DECLARE
59: cst_no CONSTANT CHAR := 'N';
60: cst_yes CONSTANT CHAR := 'Y';
61: v_step_order_num IGS_LOOKUPS_view.step_type_restriction_num_ind%TYPE;
62: CURSOR c_order(
63: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
64: SELECT sasgt.step_order_applicable_ind
65: FROM IGS_LOOKUPS_view sasgt,

Line 65: FROM IGS_LOOKUPS_view sasgt,

61: v_step_order_num IGS_LOOKUPS_view.step_type_restriction_num_ind%TYPE;
62: CURSOR c_order(
63: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
64: SELECT sasgt.step_order_applicable_ind
65: FROM IGS_LOOKUPS_view sasgt,
66: IGS_LOOKUPS_view sast
67: WHERE sasgt.lookup_code = sast.step_group_type AND
68: sast.lookup_code = cp_s_admission_step_type AND
69: sast.lookup_type = 'ADMISSION_STEP_TYPE' AND --2402377

Line 66: IGS_LOOKUPS_view sast

62: CURSOR c_order(
63: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
64: SELECT sasgt.step_order_applicable_ind
65: FROM IGS_LOOKUPS_view sasgt,
66: IGS_LOOKUPS_view sast
67: WHERE sasgt.lookup_code = sast.step_group_type AND
68: sast.lookup_code = cp_s_admission_step_type AND
69: sast.lookup_type = 'ADMISSION_STEP_TYPE' AND --2402377
70: sasgt.lookup_Type = 'ADM_STEP_GROUP_TYPE'; --2402377

Line 112: IGS_LOOKUPS_view.step_type_restriction_num_ind%TYPE;

108: DECLARE
109: cst_no CONSTANT CHAR := 'N';
110: cst_yes CONSTANT CHAR := 'Y';
111: v_step_type_rest_num_ind
112: IGS_LOOKUPS_view.step_type_restriction_num_ind%TYPE;
113: CURSOR c_rstrct(
114: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
115: SELECT sast.step_type_restriction_num_ind
116: FROM IGS_LOOKUPS_view sast

Line 116: FROM IGS_LOOKUPS_view sast

112: IGS_LOOKUPS_view.step_type_restriction_num_ind%TYPE;
113: CURSOR c_rstrct(
114: cp_s_admission_step_type IGS_AD_PRCS_CAT_STEP.s_admission_step_type%TYPE) IS
115: SELECT sast.step_type_restriction_num_ind
116: FROM IGS_LOOKUPS_view sast
117: WHERE sast.lookup_code = cp_s_admission_step_type AND
118: sast.lookup_Type = 'ADMISSION_STEP_TYPE';
119: BEGIN
120: -- Set the default message number

Line 160: v_closed_ind IGS_LOOKUPS_view.closed_ind%type;

156: gv_other_detail VARCHAR2(255);
157: BEGIN -- ADMP_VAL_SASTY_CLOSED
158: -- Validate if s_admission_step_type.s_admission_step_type is closed.
159: DECLARE
160: v_closed_ind IGS_LOOKUPS_view.closed_ind%type;
161: CURSOR c_sasty IS
162: SELECT sasty.closed_ind
163: FROM IGS_LOOKUPS_view sasty
164: WHERE sasty.lookup_code = p_s_admission_step_type AND

Line 163: FROM IGS_LOOKUPS_view sasty

159: DECLARE
160: v_closed_ind IGS_LOOKUPS_view.closed_ind%type;
161: CURSOR c_sasty IS
162: SELECT sasty.closed_ind
163: FROM IGS_LOOKUPS_view sasty
164: WHERE sasty.lookup_code = p_s_admission_step_type AND
165: sasty.lookup_type = 'ADMISSION_STEP_TYPE';
166: BEGIN
167: -- Set the default message number