APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_INPUT_VALUES_F

Line 765: from pay_input_values_f

761: where balance_classification_id = p_core_object_id;
762: --
763: cursor csr_siv_core_object_exists(p_core_object_id in number) is
764: select count(0)
765: from pay_input_values_f
766: where input_value_id = p_core_object_id;
767: --
768: cursor csr_sbf_core_object_exists(p_core_object_id in number) is
769: select count(0)

Line 2059: -- Note: in R11i, this cursor looks for 'Pay Value' on the pay_input_values_f

2055: -- Cursor to detect an input value of a given name for a given
2056: -- element_type_id exists. Don't need to worry about date-track because
2057: -- this cursor is only executed if element_type_id is that of a newly
2058: -- created element.
2059: -- Note: in R11i, this cursor looks for 'Pay Value' on the pay_input_values_f
2060: -- base table whereas, in R11 the translated name appears on the base table.
2061: --
2062: cursor csr_input_value
2063: (p_element_type_id in number

Line 2083: from pay_input_values_f

2079: , default_value
2080: , max_value
2081: , min_value
2082: , warning_or_error
2083: from pay_input_values_f
2084: where element_type_id = p_element_type_id
2085: and name = 'Pay Value';
2086: --
2087: l_input_value csr_input_value%rowtype;

Line 2512: hr_utility.set_message_token('FK_TABLE', 'PAY_INPUT_VALUES_F');

2508: p_siv_core_objects(l_shadow_input_value_id).core_object_id;
2509: else
2510: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2511: hr_utility.set_message_token('TABLE', 'PAY_STATUS_PROCESSING_RULES_F');
2512: hr_utility.set_message_token('FK_TABLE', 'PAY_INPUT_VALUES_F');
2513: hr_utility.raise_error;
2514: end if;
2515: end if;
2516: --

Line 2646: hr_utility.set_message_token('FK_TABLE', 'PAY_INPUT_VALUES_F');

2642: p_siv_core_objects(l_shadow_input_value_id).core_object_id;
2643: else
2644: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2645: hr_utility.set_message_token('TABLE', 'PAY_ITERATIVE_RULES_F');
2646: hr_utility.set_message_token('FK_TABLE', 'PAY_INPUT_VALUES_F');
2647: hr_utility.raise_error;
2648: end if;
2649: end if;
2650: --

Line 3528: from pay_input_values_f

3524: cursor csr_input_values_lock(p_input_value_id in number) is
3525: select input_value_id
3526: , rowid
3527: , effective_start_date
3528: from pay_input_values_f
3529: where input_value_id = p_input_value_id
3530: for update of input_value_id;
3531: --
3532: cursor csr_status_rules_lock(p_status_processing_rule_id in number) is