DBA Data[Home] [Help]

APPS.IGS_EN_GEN_008 dependencies on IGS_PE_USR_ARG_ALL

Line 2281: FROM IGS_PE_USR_ARG_ALL pua,

2277: SELECT nvl(dai.absolute_val,
2278: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,
2279: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,
2280: dai.DT_ALIAS, dai.sequence_number) ) ) alias_val
2281: FROM IGS_PE_USR_ARG_ALL pua,
2282: IGS_CA_DA_INST dai
2283: WHERE pua.person_type = cp_person_type
2284: AND dai.dt_alias = pua.grad_sch_dt_alias
2285: AND dai.cal_type = p_cal_type

Line 2514: FROM igs_ca_da_inst dai,igs_pe_usr_arg_all pua

2510: SELECT nvl(dai.absolute_val,
2511: IGS_CA_GEN_001.calp_set_alias_value(dai.absolute_val,
2512: IGS_CA_GEN_002.cals_clc_dt_from_dai(dai.ci_sequence_number, dai.CAL_TYPE,
2513: dai.DT_ALIAS, dai.sequence_number) ) ) alias_val
2514: FROM igs_ca_da_inst dai,igs_pe_usr_arg_all pua
2515: WHERE pua.person_type = cp_person_type
2516: AND dai.dt_alias = pua.grad_sch_dt_alias
2517: AND dai.cal_type = p_cal_type
2518: AND dai.ci_sequence_number = p_ci_sequence_number