APPS.HR_ACCRUAL_PLAN_API dependencies on PER_BUSINESS_GROUPS

Line 497: from per_business_groups

493: begin
494: --
495: select legislation_code
496: into l_leg_code
497: from per_business_groups
498: where business_group_id = p_business_group_id;
499: --
500: exception
501: when no_data_found then

Line 553: l_legislation_code per_business_groups.legislation_code%TYPE;

549: ,p_business_group_id IN NUMBER)
550: IS
551:
552: l_proc VARCHAR2(80);
553: l_legislation_code per_business_groups.legislation_code%TYPE;
554: l_dummy NUMBER;
555:
556: --
557: -- Gets the legislation code.

Line 561: FROM per_business_groups pbg

557: -- Gets the legislation code.
558: --
559: CURSOR csr_get_leg_code IS
560: SELECT pbg.legislation_code
561: FROM per_business_groups pbg
562: WHERE pbg.business_group_id = p_business_group_id;
563:
564: --
565: -- Validates the balance dimension.

Line 983: from per_business_groups

979: --
980:
981: select name, legislation_code, currency_code
982: into l_bg_name, l_leg_code, l_curr_code
983: from per_business_groups
984: where business_group_id = p_business_group_id;
985:
986: hr_utility.set_location(l_proc, 40);
987: hr_utility.trace('l_bg_name: '||l_bg_name);

Line 2223: l_bg_name per_business_groups.name%TYPE;

2219: l_element_name varchar2(80);
2220: l_input_value_name varchar2(80);
2221: l_primary_classification_id number;
2222: l_classification_type varchar2(2);
2223: l_bg_name per_business_groups.name%TYPE;
2224: l_curr_code varchar2(150);
2225: l_classification_name varchar2(240);
2226: l_post_termination_rule varchar2(240);
2227: l_temp_ovn number;

Line 2384: from per_business_groups

2380: -- the elements with the correct leg code and currency code.
2381: --
2382: select name, legislation_code, currency_code
2383: into l_bg_name, l_leg_code, l_curr_code
2384: from per_business_groups
2385: where business_group_id = l_plan_rec.business_group_id;
2386:
2387: hr_utility.trace('l_bg_name: '||l_bg_name);
2388: hr_utility.trace('l_leg_code: '||l_leg_code);