DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_ELIGY_PRFL_F

Line 886: ben_eligy_prfl_f elp,

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
889: epa.pgm_id = p_pgm_id or
890: epa.plip_id = p_plip_id or

Line 909: ben_eligy_prfl_f elp,

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
912: epa.pgm_id = p_pgm_id or
913: epa.plip_id = p_plip_id or

Line 932: ben_eligy_prfl_f elp,

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
935: epa.pgm_id = p_pgm_id or
936: epa.plip_id = p_plip_id or