DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_ITERATIVE_RULES_F

Line 788: from pay_iterative_rules_f

784: where status_processing_rule_id = p_core_object_id;
785: --
786: cursor csr_sir_core_object_exists(p_core_object_id in number) is
787: select count(0)
788: from pay_iterative_rules_f
789: where iterative_rule_id = p_core_object_id;
790: --
791: cursor csr_seu_core_object_exists(p_core_object_id in number) is
792: select count(0)

Line 2663: hr_utility.set_message_token('TABLE', 'PAY_ITERATIVE_RULES_F');

2659: l_input_value_id :=
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;

Line 2681: hr_utility.set_message_token('TABLE', 'PAY_ITERATIVE_RULES_F');

2677: l_element_type_id :=
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;

Line 3570: from pay_iterative_rules_f

3566: cursor csr_iterative_rules_lock(p_iterative_rule_id in number) is
3567: select iterative_rule_id
3568: , object_version_number
3569: , effective_start_date
3570: from pay_iterative_rules_f
3571: where iterative_rule_id = p_iterative_rule_id
3572: for update of iterative_rule_id;
3573: --
3574: cursor csr_ele_type_usages_lock(p_element_type_usage_id in number) is