APPS.IGS_PR_GEN_005 dependencies on IGS_CA_DA_INST

Line 695: FROM igs_ca_da_inst dai

691: dai.sequence_number,
692: dai.cal_type,
693: dai.ci_sequence_number
694: )
695: FROM igs_ca_da_inst dai
696: WHERE dai.cal_type = p_prg_cal_type
697: AND dai.ci_sequence_number = p_prg_sequence_number
698: AND dai.dt_alias = cp_dt_alias
699: ORDER BY 1;

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

760: ) RETURN DATE IS
761: gv_other_detail VARCHAR2 (255);
762: BEGIN -- IGS_PR_get_prg_pen_end
763: -- Get the encumbrance end date of the nominated progression period.
764: -- This is retrieved from the IGS_CA_DA_INST table matching the value
765: -- stored in the progression configuration table. If no date alias is found,
766: -- then the end date of the progression period is returned.
767: DECLARE
768: v_alias_val DATE;

Line 780: FROM igs_ca_da_inst dai,

776: dai.cal_type,
777: dai.ci_sequence_number
778: )
779: )
780: FROM igs_ca_da_inst dai,
781: igs_pr_s_prg_conf spc
782: WHERE dai.cal_type = p_prg_cal_type
783: AND dai.ci_sequence_number = p_prg_sequence_number
784: AND dai.dt_alias = spc.encumb_end_dt_alias