APPS.PAY_BLT_BUS dependencies on PAY_BALANCE_TYPES

Line 31: , pay_balance_types blt

27: cursor csr_sec_grp is
28: select pbg.security_group_id,
29: pbg.legislation_code
30: from per_business_groups_perf pbg
31: , pay_balance_types blt
32: where blt.balance_type_id = p_balance_type_id
33: and pbg.business_group_id (+) = blt.business_group_id;
34: --
35: -- Declare local variables

Line 101: , pay_balance_types blt

97: --
98: cursor csr_leg_code is
99: select pbg.legislation_code
100: from per_business_groups_perf pbg
101: , pay_balance_types blt
102: where blt.balance_type_id = p_balance_type_id
103: and pbg.business_group_id (+) = blt.business_group_id;
104: --
105: -- Declare local variables

Line 249: ,p_descflex_name => 'PAY_BALANCE_TYPES'

245: -- b) During insert.
246: --
247: hr_dflex_utility.ins_or_upd_descflex_attribs
248: (p_appl_short_name => 'PAY'
249: ,p_descflex_name => 'PAY_BALANCE_TYPES'
250: ,p_attribute_category => p_rec.ATTRIBUTE_CATEGORY
251: ,p_attribute1_name => 'ATTRIBUTE1'
252: ,p_attribute1_value => p_rec.attribute1
253: ,p_attribute2_name => 'ATTRIBUTE2'

Line 316: pay_balance_types_pkg.chk_balance_type

312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314:
315: if p_assignment_remuneration_flag = 'Y' then
316: pay_balance_types_pkg.chk_balance_type
317: ( p_row_id => null,
318: p_business_group_id => p_business_group_id,
319: p_legislation_code => nvl(p_legislation_code,
320: hr_api.return_legislation_code(p_business_group_id)),

Line 398: from pay_balance_types_tl

394: l_dbi_exists varchar2(1);
395: --
396: cursor chk_source_lang is
397: select '1'
398: from pay_balance_types_tl
399: where balance_type_id = p_balance_type_id
400: and source_lang <> userenv('LANG');
401:
402: cursor chk_db_items is

Line 413: pay_balance_types_pkg.chk_balance_type

409: --
410: Begin
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: pay_balance_types_pkg.chk_balance_type
414: (null,
415: p_business_group_id,
416: p_legislation_code,
417: p_balance_name,

Line 561: pay_balance_types_pkg.chk_balance_type

557: --
558: Begin
559: hr_utility.set_location('Entering:'||l_proc, 5);
560: --
561: pay_balance_types_pkg.chk_balance_type
562: (null,
563: p_business_group_id,
564: p_legislation_code,
565: null,

Line 602: pay_balance_types_pkg.chk_balance_category_rule(

598: Begin
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: if (p_balance_category_id is null and
602: pay_balance_types_pkg.chk_balance_category_rule(
603: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))) then
604: hr_api.mandatory_arg_error
605: (p_api_name => l_proc
606: ,p_argument => 'balance_category_id'

Line 646: from pay_balance_types

642:
643: Cursor c_chk_base_balance
644: is
645: select '1'
646: from pay_balance_types
647: where base_balance_type_id is null
648: and balance_type_id = p_base_balance_type_id
649: and ((p_business_group_id is not null
650: and nvl(business_group_id,-1) = p_business_group_id