APPS.PAY_PAP_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: l_legislation_code per_business_groups.legislation_code%TYPE;

25: ,p_formula_type_name IN VARCHAR2) RETURN VARCHAR2
26: IS
27:
28: l_proc VARCHAR2(72) := g_package||'return_ff_name';
29: l_legislation_code per_business_groups.legislation_code%TYPE;
30: l_formula_name ff_formulas_f.formula_name%TYPE;
31:
32: --
33: -- Fetches the legislation code of the business group.

Line 37: FROM per_business_groups pbg

33: -- Fetches the legislation code of the business group.
34: --
35: CURSOR csr_get_leg_code IS
36: SELECT pbg.legislation_code
37: FROM per_business_groups pbg
38: WHERE pbg.business_group_id = p_business_group_id;
39:
40: --
41: -- Fetches the FF name whilst verifying that the formula type

Line 631: FROM per_business_groups pbg

627: -- Defining a cursor to get the legislation_code of the business group
628: --
629: CURSOR csr_get_leg_code IS
630: SELECT pbg.legislation_code
631: FROM per_business_groups pbg
632: WHERE pbg.business_group_id = p_business_group_id;
633: --
634: BEGIN
635:

Line 766: FROM per_business_groups pbg

762: FROM pay_legislation_rules plr
763: WHERE plr.rule_type = 'PTO_BALANCE_TYPE'
764: AND plr.legislation_code =
765: (SELECT pbg.legislation_code
766: FROM per_business_groups pbg
767: WHERE pbg.business_group_id = p_business_group_id);
768:
769: BEGIN
770:

Line 1306: from per_business_Groups

1302: l_proc varchar2(72) := g_package||'chk_ddf_context';
1303: l_api_updating boolean;
1304: l_legislation_code varchar2(30);
1305: cursor csr_leg_code is select legislation_code
1306: from per_business_Groups
1307: where business_group_id = p_business_Group_id;
1308: l_accrual_meaning varchar2(80);
1309: --
1310: Begin

Line 1679: from per_business_groups a,

1675: -- Declare cursor
1676: --
1677: cursor csr_leg_code is
1678: select a.legislation_code
1679: from per_business_groups a,
1680: pay_accrual_plans b
1681: where b.accrual_plan_id = p_accrual_plan_id
1682: and a.business_group_id = b.business_group_id;
1683: --

Line 1735: from per_business_groups pbg

1731: -- Declare cursor
1732: --
1733: cursor csr_sec_grp is
1734: select pbg.security_group_id
1735: from per_business_groups pbg
1736: , pay_accrual_plans pap
1737: where pap.accrual_plan_id = p_accrual_plan_id
1738: and pbg.business_group_id = pap.business_group_id
1739: order by pap.accrual_plan_name;