DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_ITERATIVE_RULES_F

Line 785: from pay_iterative_rules_f

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

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

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

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

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

Line 3552: from pay_iterative_rules_f

3548: cursor csr_iterative_rules_lock(p_iterative_rule_id in number) is
3549: select iterative_rule_id
3550: , object_version_number
3551: , effective_start_date
3552: from pay_iterative_rules_f
3553: where iterative_rule_id = p_iterative_rule_id
3554: for update of iterative_rule_id;
3555: --
3556: cursor csr_ele_type_usages_lock(p_element_type_usage_id in number) is