APPS.BEN_COLLAPSE_LIFE_EVENT dependencies on BEN_CLPSE_LF_EVT_F

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

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

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

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

Line 223: (p_events in ben_clpse_lf_evt_f%rowtype,

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

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

788: end if;
789: --
790: end add_expression;
791: --
792: function build_boolean_expression(p_events in ben_clpse_lf_evt_f%rowtype,
793: p_in_string in varchar2)
794: return varchar2 is
795: --
796: l_proc varchar2(80) := g_package||'build_boolean_expression';

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

933: raise;
934: --
935: end parse_expression;
936: --
937: function parse_and_match(p_events in ben_clpse_lf_evt_f%rowtype,
938: p_min_lf_evt_ocrd_dt in date)
939: return boolean is
940: --
941: l_proc varchar2(80) := g_package||'parse_and_match';

Line 1020: from ben_clpse_lf_evt_f clp

1016: p_effective_date in date) is
1017: --
1018: cursor c_events is
1019: select *
1020: from ben_clpse_lf_evt_f clp
1021: where clp.business_group_id = p_business_group_id
1022: and p_effective_date
1023: between clp.effective_start_date
1024: and clp.effective_end_date