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 426: from pay_balance_types_tl

422: l_dbi_exists varchar2(1);
423: --
424: cursor chk_source_lang is
425: select '1'
426: from pay_balance_types_tl
427: where balance_type_id = p_balance_type_id
428: and source_lang <> userenv('LANG');
429:
430: cursor chk_db_items is

Line 441: pay_balance_types_pkg.chk_balance_type

437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);
440: --
441: pay_balance_types_pkg.chk_balance_type
442: (null,
443: p_business_group_id,
444: p_legislation_code,
445: p_balance_name,

Line 589: pay_balance_types_pkg.chk_balance_type

585: --
586: Begin
587: hr_utility.set_location('Entering:'||l_proc, 5);
588: --
589: pay_balance_types_pkg.chk_balance_type
590: (null,
591: p_business_group_id,
592: p_legislation_code,
593: null,

Line 630: pay_balance_types_pkg.chk_balance_category_rule(

626: Begin
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: if (p_balance_category_id is null and
630: pay_balance_types_pkg.chk_balance_category_rule(
631: nvl(p_legislation_code,hr_api.return_legislation_code(p_business_group_id)))) then
632: hr_api.mandatory_arg_error
633: (p_api_name => l_proc
634: ,p_argument => 'balance_category_id'

Line 674: from pay_balance_types

670:
671: Cursor c_chk_base_balance
672: is
673: select '1'
674: from pay_balance_types
675: where base_balance_type_id is null
676: and balance_type_id = p_base_balance_type_id
677: and ((p_business_group_id is not null
678: and nvl(business_group_id,-1) = p_business_group_id