DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BEN_ELIGY_PRFL_F

Line 890: ben_eligy_prfl_f elp,

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

Line 913: ben_eligy_prfl_f elp,

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

Line 936: ben_eligy_prfl_f elp,

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