APPS.PAY_ELEMENT_TEMPLATE_GEN dependencies on PAY_BALANCE_TYPES

Line 290: from pay_balance_types

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

Line 745: from pay_balance_types

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

Line 1222: pay_balance_types_pkg.insert_row

1218: end if;
1219: --
1220: -- Insert the balance row.
1221: --
1222: pay_balance_types_pkg.insert_row
1223: (x_rowid => l_rowid
1224: ,x_balance_type_id => l_balance_type_id
1225: ,x_business_group_id => p_business_group_id
1226: ,x_legislation_code => null

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

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

Line 3480: from pay_balance_types

3476: cursor csr_balance_types_lock(p_balance_type_id in number) is
3477: select balance_type_id
3478: , rowid
3479: , null
3480: from pay_balance_types
3481: where balance_type_id = p_balance_type_id
3482: for update of balance_type_id;
3483: --
3484: cursor csr_defined_balances_lock(p_defined_balance_id in number) is

Line 3970: from pay_balance_types pbt

3966: --
3967: cursor csr_child_balances(p_balance_type_id in number) is
3968: select pbt.balance_type_id
3969: , pbt.balance_name
3970: from pay_balance_types pbt
3971: where pbt.base_balance_type_id = p_balance_type_id;
3972: --
3973: l_balance_name varchar2(320);
3974: begin

Line 4006: from pay_balance_types pbt

4002: -- The child balance is external to the template - raise an error.
4003: --
4004: select pbt.balance_name
4005: into l_balance_name
4006: from pay_balance_types pbt
4007: where pbt.balance_type_id = p_balance_type_id
4008: ;
4009: hr_utility.set_message(801, 'PAY_50213_ETM_EXTERNAL_BAL_DEL');
4010: hr_utility.set_message_token('BASE_BALANCE', l_balance_name);

Line 4018: pay_balance_types_pkg.delete_row

4014: end loop;
4015: --
4016: -- Delete this balance.
4017: --
4018: pay_balance_types_pkg.delete_row
4019: (x_rowid => p_rowid_id_recs(p_balance_type_id).rowid
4020: ,x_balance_type_id => p_balance_type_id
4021: );
4022: end if;