APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_INPUT_VALUES_F

Line 768: from pay_input_values_f

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

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

2073: -- Cursor to detect an input value of a given name for a given
2074: -- element_type_id exists. Don't need to worry about date-track because
2075: -- this cursor is only executed if element_type_id is that of a newly
2076: -- created element.
2077: -- Note: in R11i, this cursor looks for 'Pay Value' on the pay_input_values_f
2078: -- base table whereas, in R11 the translated name appears on the base table.
2079: --
2080: cursor csr_input_value
2081: (p_element_type_id in number

Line 2101: from pay_input_values_f

2097: , default_value
2098: , max_value
2099: , min_value
2100: , warning_or_error
2101: from pay_input_values_f
2102: where element_type_id = p_element_type_id
2103: and name = 'Pay Value';
2104: --
2105: l_input_value csr_input_value%rowtype;

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

2526: p_siv_core_objects(l_shadow_input_value_id).core_object_id;
2527: else
2528: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2529: hr_utility.set_message_token('TABLE', 'PAY_STATUS_PROCESSING_RULES_F');
2530: hr_utility.set_message_token('FK_TABLE', 'PAY_INPUT_VALUES_F');
2531: hr_utility.raise_error;
2532: end if;
2533: end if;
2534: --

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

2660: p_siv_core_objects(l_shadow_input_value_id).core_object_id;
2661: else
2662: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2663: hr_utility.set_message_token('TABLE', 'PAY_ITERATIVE_RULES_F');
2664: hr_utility.set_message_token('FK_TABLE', 'PAY_INPUT_VALUES_F');
2665: hr_utility.raise_error;
2666: end if;
2667: end if;
2668: --

Line 3546: from pay_input_values_f

3542: cursor csr_input_values_lock(p_input_value_id in number) is
3543: select input_value_id
3544: , rowid
3545: , effective_start_date
3546: from pay_input_values_f
3547: where input_value_id = p_input_value_id
3548: for update of input_value_id;
3549: --
3550: cursor csr_status_rules_lock(p_status_processing_rule_id in number) is