DBA Data[Home] [Help]

APPS.BEN_EXT_EVALUATE_INCLUSION dependencies on BEN_PRTT_PREM_BY_MO_F

Line 4856: (p_last_update_date in ben_prtt_prem_by_mo_f.last_update_date%type,

4852: -- The following procedure evaluates cm_pr_last_upd_dt.
4853: -- premuim last updated date
4854: --
4855: Procedure chk_prem_last_upd_dt_incl
4856: (p_last_update_date in ben_prtt_prem_by_mo_f.last_update_date%type,
4857: p_effective_date in date,
4858: p_excld_flag in varchar2)
4859: is
4860: --

Line 4933: (p_mo_num in ben_prtt_prem_by_mo_f.mo_num%type default null,

4929: -- The following procedure evaluates chk_prem_month_year_no_incl.
4930: -- premuim month No and year no
4931: --
4932: Procedure chk_prem_month_year_no_incl
4933: (p_mo_num in ben_prtt_prem_by_mo_f.mo_num%type default null,
4934: p_yr_num in ben_prtt_prem_by_mo_f.yr_num%type default null,
4935: p_effective_date in date,
4936: p_excld_flag in varchar2)
4937: is

Line 4934: p_yr_num in ben_prtt_prem_by_mo_f.yr_num%type default null,

4930: -- premuim month No and year no
4931: --
4932: Procedure chk_prem_month_year_no_incl
4933: (p_mo_num in ben_prtt_prem_by_mo_f.mo_num%type default null,
4934: p_yr_num in ben_prtt_prem_by_mo_f.yr_num%type default null,
4935: p_effective_date in date,
4936: p_excld_flag in varchar2)
4937: is
4938: --

Line 6749: (p_last_update_date in ben_prtt_prem_by_mo_f.last_update_date%type,

6745: --
6746: -- The following procedure evaluates the extract premium inclusion criteria
6747: --
6748: Procedure evaluate_prem_incl
6749: (p_last_update_date in ben_prtt_prem_by_mo_f.last_update_date%type,
6750: p_mo_num in ben_prtt_prem_by_mo_f.mo_num%type default null ,
6751: p_yr_num in ben_prtt_prem_by_mo_f.yr_num%type default null,
6752: p_effective_date in date default null,
6753: p_include out nocopy varchar2)

Line 6750: p_mo_num in ben_prtt_prem_by_mo_f.mo_num%type default null ,

6746: -- The following procedure evaluates the extract premium inclusion criteria
6747: --
6748: Procedure evaluate_prem_incl
6749: (p_last_update_date in ben_prtt_prem_by_mo_f.last_update_date%type,
6750: p_mo_num in ben_prtt_prem_by_mo_f.mo_num%type default null ,
6751: p_yr_num in ben_prtt_prem_by_mo_f.yr_num%type default null,
6752: p_effective_date in date default null,
6753: p_include out nocopy varchar2)
6754: is

Line 6751: p_yr_num in ben_prtt_prem_by_mo_f.yr_num%type default null,

6747: --
6748: Procedure evaluate_prem_incl
6749: (p_last_update_date in ben_prtt_prem_by_mo_f.last_update_date%type,
6750: p_mo_num in ben_prtt_prem_by_mo_f.mo_num%type default null ,
6751: p_yr_num in ben_prtt_prem_by_mo_f.yr_num%type default null,
6752: p_effective_date in date default null,
6753: p_include out nocopy varchar2)
6754: is
6755: --