APPS.PQH_RBC_STAGE dependencies on PQH_RATE_MATRIX_NODES

Line 239: from pqh_rate_matrix_nodes

235: if p_node_short_code is null then
236: begin
237: select criteria_short_code
238: into l_crit_short_code
239: from pqh_rate_matrix_nodes
240: where rate_matrix_node_id = p_rate_matrix_node_id;
241: hr_utility.set_location('nodeshort_code is'||l_crit_short_code,10);
242: exception
243: when others then

Line 450: from pqh_rate_matrix_rates_f rate, pqh_rate_matrix_nodes node

446: l_rcr_cer_id number;
447: l_rcr_cer_ovn number;
448: l_count number := 0;
449: cursor c_matx_rates is select distinct rate.criteria_rate_defn_id
450: from pqh_rate_matrix_rates_f rate, pqh_rate_matrix_nodes node
451: where node.pl_id = p_rate_matrix_id
452: and node.rate_matrix_node_id = rate.rate_matrix_node_id
453: and p_effective_date between effective_start_date and effective_end_date;
454: l_min varchar2(150);

Line 1660: from pqh_rate_matrix_nodes

1656: l_status_flag number := 0;
1657: l_parent_id number;
1658: /**
1659: cursor c_crit is select distinct criteria_short_code,level_number
1660: from pqh_rate_matrix_nodes
1661: where pl_id = p_rate_matrix_id
1662: and criteria_short_code is not null
1663: order by level_number;
1664: **/

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 1674: cursor c_node is select * from pqh_rate_matrix_nodes

1670: and p_effective_date between b.effective_start_date and b.effective_end_date
1671: order by a.level_number;
1672: --
1673: /**
1674: cursor c_node is select * from pqh_rate_matrix_nodes
1675: where pl_id = p_rate_matrix_id
1676: order by level_number;
1677: **/
1678: cursor c_node is select a.* from pqh_rate_matrix_nodes a

Line 1678: cursor c_node is select a.* from pqh_rate_matrix_nodes a

1674: cursor c_node is select * from pqh_rate_matrix_nodes
1675: where pl_id = p_rate_matrix_id
1676: order by level_number;
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