APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_ELEMENT_TYPES_F

Line 336: from pay_element_types_f

332: ,p_legislation_code in varchar2
333: ,p_element_name in varchar2
334: ) is
335: select element_type_id
336: from pay_element_types_f
337: where upper(element_name) = p_element_name
338: and p_effective_date between
339: effective_start_date and nvl(effective_end_date, hr_api.g_eot)
340: and

Line 743: from pay_element_types_f

739: where formula_id = p_core_object_id;
740: --
741: cursor csr_set_core_object_exists(p_core_object_id in number) is
742: select count(0)
743: from pay_element_types_f
744: where element_type_id = p_core_object_id;
745: --
746: cursor csr_sbt_core_object_exists(p_core_object_id in number) is
747: select count(0)

Line 2510: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');

2506: p_spr_core_objects(l_shadow_element_type_id).core_object_id;
2507: else
2508: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2509: hr_utility.set_message_token('TABLE', 'PAY_STATUS_PROCESSING_RULES_F');
2510: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');
2511: hr_utility.raise_error;
2512: end if;
2513: -------------------------------------------------------------------
2514: -- Set up the element_type_id and input_value_id columns for the --

Line 2548: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');

2544: p_set_core_objects(l_shadow_element_type_id).core_object_id;
2545: else
2546: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2547: hr_utility.set_message_token('TABLE', 'PAY_STATUS_PROCESSING_RULES_F');
2548: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');
2549: hr_utility.raise_error;
2550: end if;
2551: elsif p_formula_rules(i).element_name is not null then
2552: l_element_type_id :=

Line 2682: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');

2678: p_set_core_objects(l_shadow_element_type_id).core_object_id;
2679: else
2680: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2681: hr_utility.set_message_token('TABLE', 'PAY_ITERATIVE_RULES_F');
2682: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');
2683: hr_utility.raise_error;
2684: end if;
2685: end if;
2686: ------------------------------------

Line 2908: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');

2904: p_set_core_objects(p_gu_bal_exclusions(i).source_id).core_object_id;
2905: else
2906: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2907: hr_utility.set_message_token('TABLE', 'PAY_GROSSUP_BAL_EXCLUSIONS');
2908: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');
2909: hr_utility.raise_error;
2910: end if;
2911: end if;
2912: --

Line 3514: from pay_element_types_f

3510: cursor csr_element_types_lock(p_element_type_id in number) is
3511: select element_type_id
3512: , rowid
3513: , effective_start_date
3514: from pay_element_types_f
3515: where element_type_id = p_element_type_id
3516: for update of element_type_id;
3517: --
3518: cursor csr_balance_feeds_lock(p_balance_feed_id in number) is