APPS.PQH_RBC_UTILITY dependencies on PQH_RATE_MATRIX_RATES_F

Line 1087: cursor c1 is select rate_matrix_rate_id from pqh_rate_matrix_rates_f

1083: FUNCTION check_criteria_rate_under_use(p_criteria_rate_defn_id NUMBER) RETURN varchar2 IS
1084: l_rate_matrix_rate_id number;
1085: l_rate_matrix_rate_id2 number;
1086: l_ret_vlaue varchar2(3);
1087: cursor c1 is select rate_matrix_rate_id from pqh_rate_matrix_rates_f
1088: where criteria_rate_defn_id = p_criteria_rate_defn_id;
1089: cursor c2 is select information1 from ben_copy_entity_results where
1090: information1 = p_criteria_rate_defn_id and table_alias = 'RCR';
1091: BEGIN

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;