eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_RBC_LOAD_OBJECTS dependencies on PQH_RATE_MATRIX_NODES

Line 185: l_rate_matrix_node_id pqh_rate_matrix_nodes.rate_matrix_node_id%type;

181: l_pl_id ben_pl_f.pl_id%type ;
182: l_eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type;
183: l_business_group_id hr_all_organization_units.business_group_id%type;
184: --
185: l_rate_matrix_node_id pqh_rate_matrix_nodes.rate_matrix_node_id%type;
186: l_parent_node_id pqh_rate_matrix_nodes.parent_node_id%type;
187: l_ovn number := 1;
188: l_effective_date date;
189: --

Line 186: l_parent_node_id pqh_rate_matrix_nodes.parent_node_id%type;

182: l_eligy_prfl_id ben_eligy_prfl_f.eligy_prfl_id%type;
183: l_business_group_id hr_all_organization_units.business_group_id%type;
184: --
185: l_rate_matrix_node_id pqh_rate_matrix_nodes.rate_matrix_node_id%type;
186: l_parent_node_id pqh_rate_matrix_nodes.parent_node_id%type;
187: l_ovn number := 1;
188: l_effective_date date;
189: --
190: --

Line 191: l_created_by pqh_rate_matrix_nodes.created_by%TYPE;

187: l_ovn number := 1;
188: l_effective_date date;
189: --
190: --
191: l_created_by pqh_rate_matrix_nodes.created_by%TYPE;
192: l_last_updated_by pqh_rate_matrix_nodes.last_updated_by%TYPE;
193: l_creation_date pqh_rate_matrix_nodes.creation_date%TYPE;
194: l_last_update_date pqh_rate_matrix_nodes.last_update_date%TYPE;
195: l_last_update_login pqh_rate_matrix_nodes.last_update_login%TYPE;

Line 192: l_last_updated_by pqh_rate_matrix_nodes.last_updated_by%TYPE;

188: l_effective_date date;
189: --
190: --
191: l_created_by pqh_rate_matrix_nodes.created_by%TYPE;
192: l_last_updated_by pqh_rate_matrix_nodes.last_updated_by%TYPE;
193: l_creation_date pqh_rate_matrix_nodes.creation_date%TYPE;
194: l_last_update_date pqh_rate_matrix_nodes.last_update_date%TYPE;
195: l_last_update_login pqh_rate_matrix_nodes.last_update_login%TYPE;
196: --

Line 193: l_creation_date pqh_rate_matrix_nodes.creation_date%TYPE;

189: --
190: --
191: l_created_by pqh_rate_matrix_nodes.created_by%TYPE;
192: l_last_updated_by pqh_rate_matrix_nodes.last_updated_by%TYPE;
193: l_creation_date pqh_rate_matrix_nodes.creation_date%TYPE;
194: l_last_update_date pqh_rate_matrix_nodes.last_update_date%TYPE;
195: l_last_update_login pqh_rate_matrix_nodes.last_update_login%TYPE;
196: --
197: --

Line 194: l_last_update_date pqh_rate_matrix_nodes.last_update_date%TYPE;

190: --
191: l_created_by pqh_rate_matrix_nodes.created_by%TYPE;
192: l_last_updated_by pqh_rate_matrix_nodes.last_updated_by%TYPE;
193: l_creation_date pqh_rate_matrix_nodes.creation_date%TYPE;
194: l_last_update_date pqh_rate_matrix_nodes.last_update_date%TYPE;
195: l_last_update_login pqh_rate_matrix_nodes.last_update_login%TYPE;
196: --
197: --
198: --

Line 195: l_last_update_login pqh_rate_matrix_nodes.last_update_login%TYPE;

191: l_created_by pqh_rate_matrix_nodes.created_by%TYPE;
192: l_last_updated_by pqh_rate_matrix_nodes.last_updated_by%TYPE;
193: l_creation_date pqh_rate_matrix_nodes.creation_date%TYPE;
194: l_last_update_date pqh_rate_matrix_nodes.last_update_date%TYPE;
195: l_last_update_login pqh_rate_matrix_nodes.last_update_login%TYPE;
196: --
197: --
198: --
199: -- rate matrix node

Line 203: from pqh_rate_matrix_nodes

199: -- rate matrix node
200: --
201: Cursor csr_rmn(p_code in varchar2) is
202: select rate_matrix_node_id
203: from pqh_rate_matrix_nodes
204: Where short_code = p_code
205: and business_group_id = l_business_group_id;
206: --
207: -- plan corresponding to Rate matrix.

Line 277: Update pqh_rate_matrix_nodes

273: --
274: If l_rate_matrix_node_id is not null then
275:
276: --
277: Update pqh_rate_matrix_nodes
278: set
279: RATE_MATRIX_NODE_ID = l_rate_matrix_node_id,
280: SHORT_CODE = p_node_short_code,
281: PL_ID = l_pl_id,

Line 296: Insert into pqh_rate_matrix_nodes

292: Where rate_matrix_node_id = l_rate_matrix_node_id;
293: --
294: Else
295: --
296: Insert into pqh_rate_matrix_nodes
297: (
298: RATE_MATRIX_NODE_ID,
299: SHORT_CODE,
300: PL_ID,

Line 317: pqh_rate_matrix_nodes_s.nextval,

313: OBJECT_VERSION_NUMBER
314: )
315: Values
316: (
317: pqh_rate_matrix_nodes_s.nextval,
318: p_node_short_code,
319: l_pl_id,
320: p_level_number,
321: p_criteria_short_code,

Line 361: l_rate_matrix_node_id pqh_rate_matrix_nodes.rate_matrix_node_id%type;

357: ,p_owner in varchar2
358: ) is
359: --
360: l_business_group_id hr_all_organization_units.business_group_id%type;
361: l_rate_matrix_node_id pqh_rate_matrix_nodes.rate_matrix_node_id%type;
362: --
363: l_node_value_id pqh_rt_matrix_node_values.node_value_id%type;
364: l_ovn number := 1;
365: l_effective_date date;

Line 380: from pqh_rate_matrix_nodes

376: -- rate matrix node
377: --
378: Cursor csr_rmn(p_code in varchar2) is
379: select rate_matrix_node_id
380: from pqh_rate_matrix_nodes
381: Where short_code = p_code
382: and business_group_id = l_business_group_id;
383: --
384: --

Line 548: Select rate_matrix_node_id, pl_id from pqh_rate_matrix_nodes

544: --
545: -- Create a abr corresponding to Criteria rate defn in Rate matrix.
546: --
547: Cursor csr_plan is
548: Select rate_matrix_node_id, pl_id from pqh_rate_matrix_nodes
549: Where short_code = p_node_short_code
550: and business_group_id = l_business_group_id;
551: --
552: Cursor csr_plan_name is