APPS.IGS_AD_SS_APPL_UPD_PAGE dependencies on IGS_AD_PECRS_OFOP_DT

Line 346: FROM igs_ad_pecrs_ofop_dt pod, igs_ca_da_inst dai

342: SELECT IGS_CA_GEN_001.calp_set_alias_value(
343: dai.absolute_val,
344: IGS_CA_GEN_002.cals_clc_dt_from_dai(
345: dai.ci_sequence_number, dai.CAL_TYPE, dai.DT_ALIAS, dai.sequence_number) ) adm_appl_due_dt_alias
346: FROM igs_ad_pecrs_ofop_dt pod, igs_ca_da_inst dai
347: WHERE dai.dt_alias = pod.dt_alias
348: AND dai.sequence_number = pod.dai_sequence_number
349: AND pod.adm_cal_type = c_adm_cal_type
350: AND pod.adm_ci_sequence_number = c_adm_sequence_number

Line 375: l_s_adm_prcs_type igs_ad_pecrs_ofop_dt.s_admission_process_type%TYPE;

371: l_adm_due_date_alias igs_ca_da_inst_v.alias_val%TYPE;
372: l_adm_cal_type igs_ca_inst.cal_type%TYPE;
373: l_adm_sequence_number igs_ca_inst.sequence_number%TYPE;
374: l_admission_cat igs_ad_cat.admission_cat%TYPE;
375: l_s_adm_prcs_type igs_ad_pecrs_ofop_dt.s_admission_process_type%TYPE;
376: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
377:
378:
379: BEGIN