DBA Data[Home] [Help]

APPS.IGS_PR_GEN_001 dependencies on IGS_CA_INST_ALL

Line 549: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,

545:
546: END prgp_get_msr_efctv;
547:
548: FUNCTION prgp_get_prg_efctv(
549: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
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.

Line 550: p_prg_sequence_number IN IGS_CA_INST_ALL.sequence_number%TYPE )

546: END prgp_get_msr_efctv;
547:
548: FUNCTION prgp_get_prg_efctv(
549: p_prg_cal_type IN IGS_CA_INST_ALL.cal_type%TYPE ,
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