APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_ELEMENT_TYPES_F

Line 333: from pay_element_types_f

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

Line 740: from pay_element_types_f

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

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

2488: p_spr_core_objects(l_shadow_element_type_id).core_object_id;
2489: else
2490: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2491: hr_utility.set_message_token('TABLE', 'PAY_STATUS_PROCESSING_RULES_F');
2492: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');
2493: hr_utility.raise_error;
2494: end if;
2495: -------------------------------------------------------------------
2496: -- Set up the element_type_id and input_value_id columns for the --

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

2526: p_set_core_objects(l_shadow_element_type_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_ELEMENT_TYPES_F');
2531: hr_utility.raise_error;
2532: end if;
2533: elsif p_formula_rules(i).element_name is not null then
2534: l_element_type_id :=

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

2660: p_set_core_objects(l_shadow_element_type_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_ELEMENT_TYPES_F');
2665: hr_utility.raise_error;
2666: end if;
2667: end if;
2668: ------------------------------------

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

2886: p_set_core_objects(p_gu_bal_exclusions(i).source_id).core_object_id;
2887: else
2888: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2889: hr_utility.set_message_token('TABLE', 'PAY_GROSSUP_BAL_EXCLUSIONS');
2890: hr_utility.set_message_token('FK_TABLE', 'PAY_ELEMENT_TYPES_F');
2891: hr_utility.raise_error;
2892: end if;
2893: end if;
2894: --

Line 3496: from pay_element_types_f

3492: cursor csr_element_types_lock(p_element_type_id in number) is
3493: select element_type_id
3494: , rowid
3495: , effective_start_date
3496: from pay_element_types_f
3497: where element_type_id = p_element_type_id
3498: for update of element_type_id;
3499: --
3500: cursor csr_balance_feeds_lock(p_balance_feed_id in number) is