APPS.PER_BBT_BUS dependencies on PER_BF_BALANCE_TYPES

Line 29: , per_bf_balance_types bbt

25: --
26: cursor csr_sec_grp is
27: select inf.org_information14
28: from hr_organization_information inf
29: , per_bf_balance_types bbt
30: where bbt.balance_type_id = p_balance_type_id
31: and inf.organization_id = bbt.business_group_id
32: and inf.org_information_context || '' = 'Business Group Information';
33: --

Line 88: , per_bf_balance_types bbt

84: --
85: cursor csr_leg_code is
86: select pbg.legislation_code
87: from per_business_groups pbg
88: , per_bf_balance_types bbt
89: where bbt.balance_type_id = p_balance_type_id
90: and pbg.business_group_id = bbt.business_group_id;
91: --
92: -- Declare local variables

Line 377: FROM per_bf_balance_types

373: l_proc varchar2(72) := g_package || 'chk_display_name_uniq';
374: --
375: CURSOR c_check_display_name_uniq IS
376: SELECT 1
377: FROM per_bf_balance_types
378: WHERE( (p_balance_type_id IS NULL)
379: or (balance_type_id <> p_balance_type_id))
380: AND displayed_name = p_displayed_name
381: AND business_group_id = p_business_group_id ;

Line 462: FROM per_bf_balance_types

458: l_proc varchar2(72) := g_package || 'chk_internal_name_uniq';
459: --
460: CURSOR c_check_internal_name_uniq IS
461: SELECT 1
462: FROM per_bf_balance_types
463: WHERE( (p_balance_type_id IS NULL)
464: or (balance_type_id <> p_balance_type_id))
465: AND internal_name = p_internal_name
466: AND business_group_id = p_business_group_id ;