APPS.PQH_RFE_BUS dependencies on PQH_CRITERIA_RATE_ELEMENTS

Line 352: select null from pqh_criteria_rate_elements a

348: l_dummy varchar2(1);
349: --
350:
351: cursor c1 is
352: select null from pqh_criteria_rate_elements a
353: where a.criteria_rate_element_id = p_criteria_rate_element_id;
354:
355: --
356: Begin

Line 371: -- pqh_criteria_rate_elements table

367: <> nvl(pqh_rfe_shd.g_old_rec.criteria_rate_element_id,hr_api.g_number)
368: or not l_api_updating) then
369: --
370: -- check if criteria_rate_element_id value exists in
371: -- pqh_criteria_rate_elements table
372: --
373: open c1;
374: --
375:

Line 382: -- raise error as FK does not relate to PK in pqh_criteria_rate_elements

378: if c1%notfound then
379: --
380: close c1;
381: --
382: -- raise error as FK does not relate to PK in pqh_criteria_rate_elements
383: -- table.
384: --
385: pqh_rfe_shd.constraint_error('PQH_RATE_FACTOR_ON_ELMNTS_FK1');
386: --

Line 531: select input_value_id from pqh_criteria_rate_elements a

527:
528: --
529: /*
530: cursor c1 is
531: select input_value_id from pqh_criteria_rate_elements a
532: where a.criteria_rate_element_id = p_criteria_rate_element_id;
533: */
534:
535:

Line 537: select piv.input_value_id input_value_id from pay_input_values_f piv,pqh_criteria_rate_elements cre

533: */
534:
535:
536: cursor c1 is
537: select piv.input_value_id input_value_id from pay_input_values_f piv,pqh_criteria_rate_elements cre
538: where cre.criteria_rate_element_id = p_criteria_rate_element_id and piv.element_type_id = cre.element_type_id;
539:
540: --
541: Begin