APPS.BEN_EVALUATE_RATE_MATRIX dependencies on PQH_RATE_MATRIX_NODES

Line 33: pqh_rate_matrix_nodes rmn

29:
30: cursor c_pl is
31: select distinct pln.pl_id
32: from ben_pl_f pln,
33: pqh_rate_matrix_nodes rmn
34: where p_effective_date between pln.effective_start_date
35: and pln.effective_end_date
36: and pln.business_group_id = p_business_group_id
37: and pln.pl_id = rmn.pl_id

Line 49: from pqh_rate_matrix_nodes rmn

45: rmn.parent_node_id,
46: rmn.eligy_prfl_id,
47: rmn.business_group_id,
48: rmn.level_number
49: from pqh_rate_matrix_nodes rmn
50: start with rmn.rate_matrix_node_id in
51: (select rate_matrix_node_id
52: from pqh_rate_matrix_nodes
53: where business_group_id = p_business_group_id

Line 52: from pqh_rate_matrix_nodes

48: rmn.level_number
49: from pqh_rate_matrix_nodes rmn
50: start with rmn.rate_matrix_node_id in
51: (select rate_matrix_node_id
52: from pqh_rate_matrix_nodes
53: where business_group_id = p_business_group_id
54: and pl_id = p_pl_id
55: and parent_node_id is null)
56: connect by prior rmn.rate_matrix_node_id = rmn.parent_node_id;