APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_GROSSUP_BAL_EXCLUSIONS

Line 795: from pay_grossup_bal_exclusions

791: where element_type_usage_id = p_core_object_id;
792: --
793: cursor csr_sgb_core_object_exists(p_core_object_id in number) is
794: select count(0)
795: from pay_grossup_bal_exclusions
796: where grossup_balances_id = p_core_object_id;
797: --
798: cursor csr_sba_core_object_exists(p_core_object_id in number) is
799: select count(0)

Line 2871: hr_utility.set_message_token('TABLE', 'PAY_GROSSUP_BAL_EXCLUSIONS');

2867: l_balance_type_id :=
2868: p_sbt_core_objects(l_balance_type_id).core_object_id;
2869: else
2870: hr_utility.set_message(801, 'PAY_50066_ETM_GEN_NO_FK_ROW');
2871: hr_utility.set_message_token('TABLE', 'PAY_GROSSUP_BAL_EXCLUSIONS');
2872: hr_utility.set_message_token('FK_TABLE', 'PAY_BALANCE_TYPES');
2873: hr_utility.raise_error;
2874: end if;
2875: end if;

Line 2889: hr_utility.set_message_token('TABLE', 'PAY_GROSSUP_BAL_EXCLUSIONS');

2885: l_source_id :=
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;

Line 3568: from pay_grossup_bal_exclusions

3564: cursor csr_gu_bal_exclusions_lock(p_grossup_balances_id in number) is
3565: select grossup_balances_id
3566: , object_version_number
3567: , null
3568: from pay_grossup_bal_exclusions
3569: where grossup_balances_id = p_grossup_balances_id
3570: for update of grossup_balances_id;
3571: --
3572: cursor csr_bal_attributes_lock(p_balance_attribute_id in number) is