APPS.PAY_SBT_BUS dependencies on PAY_SHADOW_INPUT_VALUES

Line 373: from pay_shadow_input_values siv

369: -- Cursor to check the uom of input value matches that of the balance.
370: --
371: Cursor csr_chk_uom is
372: select null
373: from pay_shadow_input_values siv
374: where siv.input_value_id = p_input_value_id
375: and upper(siv.uom) = upper(p_balance_uom);
376: --
377: Begin

Line 620: from pay_shadow_input_values siv

616: -- Cursor to check that the input value exists.
617: --
618: Cursor csr_input_value_exists is
619: select null
620: from pay_shadow_input_values siv
621: ,pay_shadow_element_types sel
622: where siv.input_value_id = p_input_value_id
623: and siv.element_type_id = sel.element_type_id
624: and sel.template_id = p_template_id;

Line 630: from pay_shadow_input_values siv

626: -- Cursor to check the uom of input value matches that of the balance.
627: --
628: Cursor csr_chk_uom is
629: select null
630: from pay_shadow_input_values siv
631: where siv.input_value_id = p_input_value_id
632: and upper(siv.uom) = upper(p_balance_uom);
633: --
634: l_proc varchar2(72) := g_package||'chk_input_value_id';