APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_GROSSUP_BAL_EXCLUSIONS

Line 798: from pay_grossup_bal_exclusions

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

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

2885: l_balance_type_id :=
2886: p_sbt_core_objects(l_balance_type_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_BALANCE_TYPES');
2891: hr_utility.raise_error;
2892: end if;
2893: end if;

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

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

Line 3586: from pay_grossup_bal_exclusions

3582: cursor csr_gu_bal_exclusions_lock(p_grossup_balances_id in number) is
3583: select grossup_balances_id
3584: , object_version_number
3585: , null
3586: from pay_grossup_bal_exclusions
3587: where grossup_balances_id = p_grossup_balances_id
3588: for update of grossup_balances_id;
3589: --
3590: cursor csr_bal_attributes_lock(p_balance_attribute_id in number) is