DBA Data[Home] [Help]

APPS.PAY_AE_ELEMENT_TEMPLATE_PKG dependencies on PAY_INPUT_VALUES_F

Line 320: FROM pay_input_values_f

316: CURSOR csr_get_input_value_id (cp_name VARCHAR2
317: ,cp_element_type_id NUMBER) IS
318: SELECT input_value_id
319: ,effective_start_date
320: FROM pay_input_values_f
321: WHERE element_type_id = cp_element_type_id
322: AND name = cp_name;
323: rec_get_input_value_id csr_get_input_value_id%ROWTYPE;
324:

Line 414: FROM pay_input_values_f

410: IF l_value_set_id is NOT NULL THEN
411: DECLARE
412: CURSOR csr_get_ovn IS
413: SELECT object_version_number
414: FROM pay_input_values_f
415: WHERE input_value_id = l_input_value_id;
416: BEGIN
417: OPEN csr_get_ovn;
418: FETCH csr_get_ovn INTO l_ov_number;

Line 505: FROM pay_input_values_f

501:
502: DECLARE
503: CURSOR csr_get_ovn IS
504: SELECT object_version_number
505: FROM pay_input_values_f
506: WHERE input_value_id = l_input_value_id;
507: BEGIN
508: OPEN csr_get_ovn;
509: FETCH csr_get_ovn INTO l_ov_number;

Line 551: FROM pay_input_values_f

547:
548: DECLARE
549: CURSOR csr_get_ovn IS
550: SELECT object_version_number
551: FROM pay_input_values_f
552: WHERE input_value_id = l_input_value_id;
553: BEGIN
554: OPEN csr_get_ovn;
555: FETCH csr_get_ovn INTO l_ov_number;