DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_PRTN_ELIG_F

Line 884: from ben_prtn_elig_f epa,

880: l_proc varchar2(80) := g_package||'set_fctr_object';
881: --
882: cursor c_los_fctr is
883: select 'Y'
884: from ben_prtn_elig_f epa,
885: ben_prtn_elig_prfl_f cep,
886: ben_eligy_prfl_f elp,
887: ben_elig_los_prte_f els
888: where (epa.pl_id = p_pl_id or

Line 907: from ben_prtn_elig_f epa,

903: els.effective_start_date and els.effective_end_date;
904: --
905: cursor c_age_fctr is
906: select 'Y'
907: from ben_prtn_elig_f epa,
908: ben_prtn_elig_prfl_f cep,
909: ben_eligy_prfl_f elp,
910: ben_elig_age_prte_f eap
911: where (epa.pl_id = p_pl_id or

Line 930: from ben_prtn_elig_f epa,

926: eap.effective_start_date and eap.effective_end_date;
927: --
928: cursor c_cmbn_age_los_fctr is
929: select 'Y'
930: from ben_prtn_elig_f epa,
931: ben_prtn_elig_prfl_f cep,
932: ben_eligy_prfl_f elp,
933: ben_elig_cmbn_age_los_prte_f ecp
934: where (epa.pl_id = p_pl_id or