APPS.PQH_RBC_STAGE_TO_RBC dependencies on PQH_RATE_MATRIX_NODES

Line 77: from pqh_rate_matrix_nodes

73: hr_utility.set_location('Entering get_elig_det_for_rmn',1);
74:
75: select CRITERIA_SHORT_CODE, ELIGY_PRFL_ID
76: into p_criteria_short_code, p_elig_prfl_id
77: from pqh_rate_matrix_nodes
78: where rate_matrix_node_id = p_rmn_id
79: and business_group_id = p_business_group_id;
80:
81: hr_utility.set_location('leaving get_elig_det_for_rmn',1);

Line 145: l_seq := 'PQH_RATE_MATRIX_NODES_S.NEXTVAL';

141: begin
142: hr_utility.set_location(' Inside get_short_code ',210);
143:
144: if p_table_alias = 'RMN' then
145: l_seq := 'PQH_RATE_MATRIX_NODES_S.NEXTVAL';
146: elsif p_table_alias = 'RMV' then
147: l_seq := 'PQH_RT_MATRIX_NODE_VALUES_S.NEXTVAL';
148: elsif p_table_alias = 'RMR' then
149: l_seq := 'PQH_RATE_MATRIX_RATES_S.NEXTVAL';

Line 374: PQH_RATE_MATRIX_NODES_API.delete_rate_matrix_node

370:
371: hr_utility.set_location('Entering: Delete_RMN', 10);
372: for del_rec in del_rmn loop
373:
374: PQH_RATE_MATRIX_NODES_API.delete_rate_matrix_node
375: (p_effective_date => p_effective_date
376: ,p_rate_matrix_node_id => del_rec.information1
377: ,p_object_version_number => del_rec.information265
378: );

Line 681: pqh_rate_matrix_nodes rmn

677:
678: select pl.pl_id pl_id, pl.name pl_name
679: into p_pl_id, p_pl_name
680: from ben_pl_f pl,
681: pqh_rate_matrix_nodes rmn
682: where rmn.pl_id = pl.pl_id
683: and p_effective_date between pl.effective_start_date and pl.effective_end_date
684: and rmn.rate_matrix_node_id = p_rmn_id
685: and rmn.business_group_id = p_business_group_id

Line 728: from pqh_rate_matrix_nodes

724: hr_utility.set_location('Entering get_rmn_short_code',100);
725:
726: Select short_code
727: into l_rmn_short_code
728: from pqh_rate_matrix_nodes
729: where rate_matrix_node_id = p_rmn_id
730: and business_group_id = p_business_group_id;
731:
732: hr_utility.set_location('leaving get_rmn_short_code',100);

Line 787: from ben_pl_f pl, pqh_rate_matrix_nodes rmn

783: hr_utility.set_location('rmr id'||l_rmr_id,20);
784:
785: select min(effective_start_date)
786: into l_esd
787: from ben_pl_f pl, pqh_rate_matrix_nodes rmn
788: where rmn.pl_id = pl.pl_id
789: and rmn.rate_matrix_node_id = p_rmn_id;
790:
791: if l_esd < p_effective_date then

Line 1225: PQH_RATE_MATRIX_NODES_API.create_rate_matrix_node

1221: else
1222: l_elp_id := null;
1223: end if;
1224:
1225: PQH_RATE_MATRIX_NODES_API.create_rate_matrix_node
1226: (p_effective_date => p_effective_date
1227: ,p_rate_matrix_node_id => l_rmn_id
1228: ,p_short_code => l_short_code
1229: ,p_pl_id => p_plan_id

Line 1249: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RATE_MATRIX_NODES',

1245: elsif rmn_rec.dml_operation in ('UPDATE')
1246: and l_ovn is not null
1247: and l_rmn_id is not null then
1248: hr_utility.set_location('Rate Matrix Node is being updated'||l_rmn_id,60);
1249: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RATE_MATRIX_NODES',
1250: p_key_column_name => 'RATE_MATRIX_NODE_ID',
1251: p_key_column_value => l_rmn_id
1252: );
1253: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 1259: PQH_RATE_MATRIX_NODES_API.update_rate_matrix_node

1255: fnd_message.set_name('PQH','PQH_RBC_OBJ_OVN_INVALID');
1256: fnd_message.raise_error;
1257: else
1258: begin
1259: PQH_RATE_MATRIX_NODES_API.update_rate_matrix_node
1260: (p_effective_date => p_effective_date
1261: ,p_rate_matrix_node_id => l_rmn_id
1262: ,p_short_code => rmn_rec.INFORMATION12
1263: ,p_pl_id => p_plan_id