APPS.PQH_RBC_UTILITY dependencies on PQH_RATE_MATRIX_NODES

Line 8: from pqh_rate_matrix_nodes a, ben_eligy_prfl_f b

4: function future_criteria_exist(p_copy_entity_txn_id in number) return varchar2 is
5: l_rate_matrix_id number(30);
6:
7: cursor c11(p_rate_matrix_id in number) is select distinct criteria_short_code
8: from pqh_rate_matrix_nodes a, ben_eligy_prfl_f b
9: where pl_id = p_rate_matrix_id
10: and criteria_short_code is not null
11: and a.eligy_prfl_id = b.eligy_prfl_id;
12:

Line 1148: pqh_rate_matrix_rates_f t1, pqh_rate_matrix_nodes t2

1144: FUNCTION is_used_in_matrix(p_selected_rate_matrix NUMBER, p_criteria_rate_defn_id NUMBER) RETURN varchar2 IS
1145: l_return_vlaue varchar2(1);
1146: BEGIN
1147: Select 'Y' INTO l_return_vlaue from
1148: pqh_rate_matrix_rates_f t1, pqh_rate_matrix_nodes t2
1149: Where t2.pl_id = p_selected_rate_matrix
1150: and t2.rate_matrix_node_id = t1.rate_matrix_node_id
1151: and sysdate between t1.effective_start_date and t1.effective_end_date
1152: and t1.criteria_rate_defn_id = p_criteria_rate_defn_id group by t1.criteria_rate_defn_id;