APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_TTL_PRTT_PRTE_F
Line 13155: from ben_elig_ttl_prtt_prte_f etp
13151: , etp.mn_prtt_num
13152: , etp.mx_prtt_num
13153: , etp.no_mn_prtt_num_apls_flag
13154: , etp.no_mx_prtt_num_apls_flag 13155: from ben_elig_ttl_prtt_prte_f etp 13156: where etp.eligy_prfl_id = c_eligy_prfl_id
13157: and c_effective_date
13158: between etp.effective_start_date and etp.effective_end_date
13159: order by etp.eligy_prfl_id;