APPS.IGS_CA_COMPUTE_DA_VAL_PKG dependencies on IGS_CA_DA_CONFIGS

Line 36: FROM IGS_CA_DA_CONFIGS

32:
33: CURSOR get_site_da(cp_sys_date VARCHAR2)
34: IS
35: SELECT date_alias
36: FROM IGS_CA_DA_CONFIGS
37: WHERE sys_date_type = cp_sys_date;
38:
39: l_org_unit VARCHAR2(30) := NULL;
40: l_prg_type VARCHAR2(30) := NULL;

Line 500: FROM IGS_CA_DA_CONFIGS

496: AS
497: CURSOR get_sda(cp_dt_alias VARCHAR2)
498: IS
499: SELECT sys_date_type
500: FROM IGS_CA_DA_CONFIGS
501: WHERE date_alias = cp_dt_alias;
502:
503: CURSOR get_count(cp_dt_alias VARCHAR2)
504: IS

Line 506: FROM IGS_CA_DA_CONFIGS

502:
503: CURSOR get_count(cp_dt_alias VARCHAR2)
504: IS
505: SELECT count(*)
506: FROM IGS_CA_DA_CONFIGS
507: WHERE date_alias = cp_dt_alias;
508:
509: l_sys_dt_type VARCHAR2(30);
510: l_count NUMBER;