APPS.PQH_RBC_STAGE dependencies on BEN_ELIGY_PRFL_F

Line 1666: from pqh_rate_matrix_nodes a, ben_eligy_prfl_f b

1662: and criteria_short_code is not null
1663: order by level_number;
1664: **/
1665: cursor c_crit is select distinct a.criteria_short_code,a.level_number
1666: from pqh_rate_matrix_nodes a, ben_eligy_prfl_f b
1667: where a.pl_id = p_rate_matrix_id
1668: and a.criteria_short_code is not null
1669: and a.eligy_prfl_id = b.eligy_prfl_id
1670: and p_effective_date between b.effective_start_date and b.effective_end_date

Line 1681: or exists (Select 1 from ben_eligy_prfl_f b

1677: **/
1678: cursor c_node is select a.* from pqh_rate_matrix_nodes a
1679: where a.pl_id = p_rate_matrix_id
1680: and (a.eligy_prfl_id is null
1681: or exists (Select 1 from ben_eligy_prfl_f b
1682: where a.eligy_prfl_id = b.eligy_prfl_id
1683: and p_effective_date between b.effective_start_date and b.effective_end_date))
1684: order by level_number;
1685: