APPS.IGS_FI_GEN_008 dependencies on IGS_PS_GEN_004

Line 700: SELECT igs_ps_gen_004.f_retention_offset_date(cp_n_uoo_id,

696:
697: -- Cursor to fetch retention schedules defined at Institution level.
698: -- Used if cur_ns_ft_ret and cur_ns_usec_ret both do not return any rows
699: CURSOR cur_ns_inst_ret(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
700: SELECT igs_ps_gen_004.f_retention_offset_date(cp_n_uoo_id,
701: rtn.formula_method,
702: rtn.round_method,
703: rtn.incl_wkend_duration_flag,
704: dtl.offset_value) offset_date

Line 882: igs_ps_gen_004.f_retention_offset_date(cp_n_uoo_id,

878: -- Used if cur_ns_ft_ret and cur_ns_usec_ret both do not return any rows
879: CURSOR cur_ns_inst_ret(cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
880: SELECT dtl.retention_amount,
881: dtl.retention_percent,
882: igs_ps_gen_004.f_retention_offset_date(cp_n_uoo_id,
883: rtn.formula_method,
884: rtn.round_method,
885: rtn.incl_wkend_duration_flag,
886: dtl.offset_value) offset_date