DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_PRTN_ELIG_F

Line 888: from ben_prtn_elig_f epa,

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

Line 911: from ben_prtn_elig_f epa,

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

Line 934: from ben_prtn_elig_f epa,

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