APPS.PER_BBA_BUS dependencies on PER_BF_BALANCE_AMOUNTS

Line 29: , per_bf_balance_amounts bba

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

Line 86: , per_bf_balance_amounts bba

82: --
83: cursor csr_leg_code is
84: select pbg.legislation_code
85: from per_business_groups pbg
86: , per_bf_balance_amounts bba
87: where bba.balance_amount_id = p_balance_amount_id
88: and pbg.business_group_id = bba.business_group_id;
89: --
90: -- Declare local variables

Line 251: ,p_descflex_name => 'PER_BF_BALANCE_AMOUNTS'

247: -- b) During insert.
248: --
249: hr_dflex_utility.ins_or_upd_descflex_attribs
250: (p_appl_short_name => 'PER'
251: ,p_descflex_name => 'PER_BF_BALANCE_AMOUNTS'
252: ,p_attribute_category => p_rec.bba_attribute_category
253: ,p_attribute1_name => 'BBA_ATTRIBUTE1'
254: ,p_attribute1_value => p_rec.bba_attribute1
255: ,p_attribute2_name => 'BBA_ATTRIBUTE2'

Line 445: (p_constraint_name => 'PER_BF_BALANCE_AMOUNTS_FK3');

441: --
442: -- The ID hasn't been found, so error
443: --
444: per_bba_shd.constraint_error
445: (p_constraint_name => 'PER_BF_BALANCE_AMOUNTS_FK3');
446: --
447: END IF;
448: CLOSE csr_chk_processed_asg_id;
449: --

Line 460: -- PER_BF_BALANCE_AMOUNTS

456: -- {Start Of Comments}
457: --
458: -- Description:
459: -- Check that the balance_type_id exists in the table
460: -- PER_BF_BALANCE_AMOUNTS
461: --
462: -- Pre Conditions:
463: --
464: -- In Arguments:

Line 499: (p_constraint_name => 'PER_BF_BALANCE_AMOUNTS_FK2');

495: -- The balance type either doesn't exist or is in a different BG
496: -- so error.
497: --
498: per_bba_shd.constraint_error
499: (p_constraint_name => 'PER_BF_BALANCE_AMOUNTS_FK2');
500: --
501: END IF;
502: --
503: CLOSE csr_chk_balance_type_id;