APPS.IGS_CA_VAL_QLITY dependencies on IGS_CA_DA_CONFIGS

Line 50: FROM igs_ca_Da_configs

46: CURSOR get_all_sda(cp_cal_cat VARCHAR2) IS
47: SELECT DISTINCT sys_date_type,date_alias
48: FROM
49: (SELECT sys_date_type,date_alias
50: FROM igs_ca_Da_configs
51: WHERE (res_cal_cat1 = cp_cal_cat OR
52: res_cal_cat2 = cp_cal_cat) AND
53: one_per_cal_flag = 'Y'
54: UNION ALL

Line 56: FROM igs_ca_Da_ovd_vals b,igs_ca_Da_configs a

52: res_cal_cat2 = cp_cal_cat) AND
53: one_per_cal_flag = 'Y'
54: UNION ALL
55: SELECT a.sys_date_type,b.date_alias
56: FROM igs_ca_Da_ovd_vals b,igs_ca_Da_configs a
57: WHERE a.sys_date_type = b.sys_date_type
58: AND a.one_per_cal_flag = 'Y'
59: AND ( a.res_cal_cat1 =cp_cal_cat OR
60: a.res_cal_cat2 =cp_cal_cat)

Line 68: FROM igs_ca_Da_configs

64: CURSOR get_all_sda_with_no_cal_cat IS
65: SELECT distinct sys_date_type,date_alias
66: FROM
67: (SELECT sys_date_type,date_alias
68: FROM igs_ca_Da_configs
69: WHERE one_per_cal_flag = 'Y'
70: UNION ALL
71: SELECT a.sys_date_type,b.date_alias
72: FROM igs_ca_Da_ovd_vals b,

Line 73: igs_ca_Da_configs a

69: WHERE one_per_cal_flag = 'Y'
70: UNION ALL
71: SELECT a.sys_date_type,b.date_alias
72: FROM igs_ca_Da_ovd_vals b,
73: igs_ca_Da_configs a
74: WHERE a.sys_date_type = b.sys_date_type
75: AND a.one_per_cal_flag = 'Y'
76: );
77: