APPS.BEN_COLLAPSE_LIFE_EVENT dependencies on BEN_CLPSE_LF_EVT_F

Line 156: function get_first_date(p_events in ben_clpse_lf_evt_f%rowtype) return date is

152: end included_in_events;
153: -- ----------------------------------------------------------------
154: -- get_first_date
155: -- ----------------------------------------------------------------
156: function get_first_date(p_events in ben_clpse_lf_evt_f%rowtype) return date is
157: --
158: l_proc varchar2(80) := g_package||'get_first_date';
159: --
160: begin

Line 189: function get_last_date(p_events in ben_clpse_lf_evt_f%rowtype) return date is

185: end get_first_date;
186: -- ----------------------------------------------------------------
187: -- get_last_date
188: -- ----------------------------------------------------------------
189: function get_last_date(p_events in ben_clpse_lf_evt_f%rowtype) return date is
190: --
191: l_proc varchar2(80) := g_package||'get_last_date';
192: --
193: begin

Line 222: (p_events in ben_clpse_lf_evt_f%rowtype,

218: -- ----------------------------------------------------------------
219: -- perform_collapse
220: -- ----------------------------------------------------------------
221: procedure perform_collapse
222: (p_events in ben_clpse_lf_evt_f%rowtype,
223: p_business_group_id in number,
224: p_person_id in number,
225: p_effective_date in date,
226: p_operation in out nocopy varchar2) is

Line 646: function build_boolean_expression(p_events in ben_clpse_lf_evt_f%rowtype,

642: end if;
643: --
644: end add_expression;
645: --
646: function build_boolean_expression(p_events in ben_clpse_lf_evt_f%rowtype,
647: p_in_string in varchar2)
648: return varchar2 is
649: --
650: l_proc varchar2(80) := g_package||'build_boolean_expression';

Line 791: function parse_and_match(p_events in ben_clpse_lf_evt_f%rowtype,

787: raise;
788: --
789: end parse_expression;
790: --
791: function parse_and_match(p_events in ben_clpse_lf_evt_f%rowtype,
792: p_min_lf_evt_ocrd_dt in date)
793: return boolean is
794: --
795: l_proc varchar2(80) := g_package||'parse_and_match';

Line 873: from ben_clpse_lf_evt_f clp

869: p_effective_date in date) is
870: --
871: cursor c_events is
872: select *
873: from ben_clpse_lf_evt_f clp
874: where clp.business_group_id = p_business_group_id
875: and p_effective_date
876: between clp.effective_start_date
877: and clp.effective_end_date