APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_BALANCE_TYPES

Line 293: from pay_balance_types

289: ,p_legislation_code in varchar2
290: ,p_balance in varchar2
291: ) is
292: select balance_type_id
293: from pay_balance_types
294: where upper(balance_name) = p_balance
295: and
296: (
297: (business_group_id is null and legislation_code is null)

Line 748: from pay_balance_types

744: where element_type_id = p_core_object_id;
745: --
746: cursor csr_sbt_core_object_exists(p_core_object_id in number) is
747: select count(0)
748: from pay_balance_types
749: where balance_type_id = p_core_object_id;
750: --
751: cursor csr_sdb_core_object_exists(p_core_object_id in number) is
752: select count(0)

Line 1235: pay_balance_types_pkg.insert_row

1231: end if;
1232: --
1233: -- Insert the balance row.
1234: --
1235: pay_balance_types_pkg.insert_row
1236: (x_rowid => l_rowid
1237: ,x_balance_type_id => l_balance_type_id
1238: ,x_business_group_id => p_business_group_id
1239: ,x_legislation_code => null

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

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;
2894: --

Line 3498: from pay_balance_types

3494: cursor csr_balance_types_lock(p_balance_type_id in number) is
3495: select balance_type_id
3496: , rowid
3497: , null
3498: from pay_balance_types
3499: where balance_type_id = p_balance_type_id
3500: for update of balance_type_id;
3501: --
3502: cursor csr_defined_balances_lock(p_defined_balance_id in number) is

Line 3988: from pay_balance_types pbt

3984: --
3985: cursor csr_child_balances(p_balance_type_id in number) is
3986: select pbt.balance_type_id
3987: , pbt.balance_name
3988: from pay_balance_types pbt
3989: where pbt.base_balance_type_id = p_balance_type_id;
3990: --
3991: l_balance_name varchar2(320);
3992: begin

Line 4024: from pay_balance_types pbt

4020: -- The child balance is external to the template - raise an error.
4021: --
4022: select pbt.balance_name
4023: into l_balance_name
4024: from pay_balance_types pbt
4025: where pbt.balance_type_id = p_balance_type_id
4026: ;
4027: hr_utility.set_message(801, 'PAY_50213_ETM_EXTERNAL_BAL_DEL');
4028: hr_utility.set_message_token('BASE_BALANCE', l_balance_name);

Line 4036: pay_balance_types_pkg.delete_row

4032: end loop;
4033: --
4034: -- Delete this balance.
4035: --
4036: pay_balance_types_pkg.delete_row
4037: (x_rowid => p_rowid_id_recs(p_balance_type_id).rowid
4038: ,x_balance_type_id => p_balance_type_id
4039: );
4040: end if;