eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_CA_VAL_QLITY dependencies on IGS_CA_DA_INST_V

Line 891: FROM IGS_CA_DA_INST_V daiv,

887: CURSOR c_daiv_1 (
888: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
889: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
890: SELECT 'x'
891: FROM IGS_CA_DA_INST_V daiv,
892: IGS_AD_CAL_CONF sacc
893: WHERE daiv.CAL_TYPE = cp_cal_type AND
894: daiv.ci_sequence_number = cp_ci_sequence_number AND
895: daiv.DT_ALIAS = sacc.initialise_adm_perd_dt_alias AND

Line 901: FROM IGS_CA_DA_INST_V daiv,

897: CURSOR c_daiv_2 (
898: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
899: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
900: SELECT 'x'
901: FROM IGS_CA_DA_INST_V daiv,
902: IGS_AD_CAL_CONF sacc
903: WHERE daiv.CAL_TYPE = cp_cal_type AND
904: daiv.ci_sequence_number = cp_ci_sequence_number AND
905: daiv.DT_ALIAS = sacc.adm_appl_encmb_chk_dt_alias AND

Line 911: FROM IGS_CA_DA_INST_V daiv,

907: CURSOR c_daiv_3 (
908: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
909: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
910: SELECT 'x'
911: FROM IGS_CA_DA_INST_V daiv,
912: IGS_AD_CAL_CONF sacc
913: WHERE daiv.CAL_TYPE = cp_cal_type AND
914: daiv.ci_sequence_number = cp_ci_sequence_number AND
915: daiv.DT_ALIAS = sacc.adm_appl_course_strt_dt_alias AND

Line 921: FROM IGS_CA_DA_INST_V daiv,

917: CURSOR c_daiv_4 (
918: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
919: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
920: SELECT COUNT(*)
921: FROM IGS_CA_DA_INST_V daiv,
922: IGS_AD_CAL_CONF sacc
923: WHERE daiv.CAL_TYPE = cp_cal_type AND
924: daiv.ci_sequence_number = cp_ci_sequence_number AND
925: daiv.DT_ALIAS = sacc.adm_appl_due_dt_alias AND

Line 938: FROM IGS_CA_DA_INST_V daiv,

934: CURSOR c_daiv_5 (
935: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
936: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
937: SELECT COUNT(*)
938: FROM IGS_CA_DA_INST_V daiv,
939: IGS_AD_CAL_CONF sacc
940: WHERE daiv.CAL_TYPE = cp_cal_type AND
941: daiv.ci_sequence_number = cp_ci_sequence_number AND
942: daiv.DT_ALIAS = sacc.adm_appl_final_dt_alias AND

Line 955: FROM IGS_CA_DA_INST_V daiv,

951: CURSOR c_daiv_6 (
952: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
953: cp_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
954: SELECT COUNT(*)
955: FROM IGS_CA_DA_INST_V daiv,
956: IGS_AD_CAL_CONF sacc
957: WHERE daiv.CAL_TYPE = cp_cal_type AND
958: daiv.ci_sequence_number = cp_ci_sequence_number AND
959: daiv.DT_ALIAS = sacc.adm_appl_offer_resp_dt_alias AND

Line 1525: FROM IGS_CA_DA_INST_V daiv,

1521: CURSOR c_chk_da_exists (
1522: cp_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE,
1523: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ) IS
1524: SELECT 'x'
1525: FROM IGS_CA_DA_INST_V daiv,
1526: IGS_CA_TYPE ct
1527: WHERE daiv.DT_ALIAS = cp_dt_alias AND
1528: daiv.CAL_TYPE = ct.CAL_TYPE AND
1529: ct.S_CAL_CAT <> cp_s_cal_cat;

Line 1535: FROM IGS_CA_DA_INST_V daiv,

1531: cp_dt_alias IGS_EN_CAL_CONF.load_effect_dt_alias%TYPE,
1532: cp_s_cal_cat IGS_CA_TYPE.S_CAL_CAT%TYPE ,
1533: cp_s_cal_cat1 IGS_CA_TYPE.S_CAL_CAT%TYPE) IS
1534: SELECT 'x'
1535: FROM IGS_CA_DA_INST_V daiv,
1536: IGS_CA_TYPE ct
1537: WHERE daiv.DT_ALIAS = cp_dt_alias AND
1538: daiv.CAL_TYPE = ct.CAL_TYPE AND
1539: ct.S_CAL_CAT <> cp_s_cal_cat AND

Line 2455: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,

2451: cir.sub_cal_type = cat2.CAL_TYPE AND
2452: cir.sup_cal_type = cp_cal_type AND
2453: cir.sup_ci_sequence_number = cp_sequence_number;
2454: CURSOR c_chk_census_dt (
2455: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
2456: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
2457: cp_acad_start_dt DATE,
2458: cp_acad_end_dt DATE ) IS
2459: SELECT 'x'

Line 2456: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,

2452: cir.sup_cal_type = cp_cal_type AND
2453: cir.sup_ci_sequence_number = cp_sequence_number;
2454: CURSOR c_chk_census_dt (
2455: cp_cal_type IGS_CA_DA_INST_V.CAL_TYPE%TYPE,
2456: cp_sequence_number IGS_CA_DA_INST_V.sequence_number%TYPE,
2457: cp_acad_start_dt DATE,
2458: cp_acad_end_dt DATE ) IS
2459: SELECT 'x'
2460: FROM dual

Line 2464: IGS_CA_DA_INST_V daiv

2460: FROM dual
2461: WHERE EXISTS (
2462: SELECT *
2463: FROM IGS_GE_S_GEN_CAL_CON sgcc,
2464: IGS_CA_DA_INST_V daiv
2465: WHERE sgcc.s_control_num = 1 AND
2466: daiv.CAL_TYPE = cp_cal_type AND
2467: daiv.ci_sequence_number = cp_sequence_number AND
2468: daiv.DT_ALIAS = sgcc.census_dt_alias AND

Line 2520: FROM IGS_CA_DA_INST_V daiv,

2516: CURSOR c_chk_aus (
2517: cp_cal_type IGS_CA_INST.CAL_TYPE%TYPE,
2518: cp_sequence_number IGS_CA_INST.sequence_number%TYPE ) IS
2519: SELECT DISTINCT ADMINISTRATIVE_UNIT_STATUS
2520: FROM IGS_CA_DA_INST_V daiv,
2521: IGS_PS_UNIT_DISC_CRT uddc
2522: WHERE daiv.CAL_TYPE = cp_cal_type AND
2523: ci_sequence_number = cp_sequence_number AND
2524: daiv.DT_ALIAS = uddc.unit_discont_dt_alias AND