APPS.IGS_PR_GEN_001 dependencies on IGS_CA_DA_INST

Line 554: -- This is retrieved from the IGS_CA_DA_INST table matching the value

550: p_prg_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE )
551: RETURN DATE AS
552: BEGIN -- prgp_get_prg_efctv
553: -- Get the effective date of a nominated progression period.
554: -- This is retrieved from the IGS_CA_DA_INST table matching the value
555: -- stored in the progression configuration table. If no date alias is found,
556: -- then the end date of the progression period is returned
557: DECLARE
558: v_alias_val IGS_CA_DA_INST.absolute_val%TYPE;

Line 558: v_alias_val IGS_CA_DA_INST.absolute_val%TYPE;

554: -- This is retrieved from the IGS_CA_DA_INST table matching the value
555: -- stored in the progression configuration table. If no date alias is found,
556: -- then the end date of the progression period is returned
557: DECLARE
558: v_alias_val IGS_CA_DA_INST.absolute_val%TYPE;
559: CURSOR c_dai IS
560: SELECT IGS_CA_GEN_001.calp_get_alias_val(
561: dai.dt_alias,
562: dai.sequence_number,

Line 565: FROM IGS_CA_DA_INST dai

561: dai.dt_alias,
562: dai.sequence_number,
563: dai.cal_type,
564: dai.ci_sequence_number)
565: FROM IGS_CA_DA_INST dai
566: WHERE dai.cal_type = p_prg_cal_type AND
567: dai.ci_sequence_number = p_prg_sequence_number AND
568: dt_alias =
569: (SELECT sprgcc.effective_end_dt_alias