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 605: FROM per_business_groups pbg

601: -- Defining a cursor to get the legislation_code of the business group
602: --
603: CURSOR csr_get_leg_code IS
604: SELECT pbg.legislation_code
605: FROM per_business_groups pbg
606: WHERE pbg.business_group_id = p_business_group_id;
607: --
608: BEGIN
609:

Line 740: FROM per_business_groups pbg

736: FROM pay_legislation_rules plr
737: WHERE plr.rule_type = 'PTO_BALANCE_TYPE'
738: AND plr.legislation_code =
739: (SELECT pbg.legislation_code
740: FROM per_business_groups pbg
741: WHERE pbg.business_group_id = p_business_group_id);
742:
743: BEGIN
744:

Line 1280: from per_business_Groups

1276: l_proc varchar2(72) := g_package||'chk_ddf_context';
1277: l_api_updating boolean;
1278: l_legislation_code varchar2(30);
1279: cursor csr_leg_code is select legislation_code
1280: from per_business_Groups
1281: where business_group_id = p_business_Group_id;
1282: l_accrual_meaning varchar2(80);
1283: --
1284: Begin

Line 1655: from per_business_groups a,

1651: -- Declare cursor
1652: --
1653: cursor csr_leg_code is
1654: select a.legislation_code
1655: from per_business_groups a,
1656: pay_accrual_plans b
1657: where b.accrual_plan_id = p_accrual_plan_id
1658: and a.business_group_id = b.business_group_id;
1659: --

Line 1711: from per_business_groups pbg

1707: -- Declare cursor
1708: --
1709: cursor csr_sec_grp is
1710: select pbg.security_group_id
1711: from per_business_groups pbg
1712: , pay_accrual_plans pap
1713: where pap.accrual_plan_id = p_accrual_plan_id
1714: and pbg.business_group_id = pap.business_group_id
1715: order by pap.accrual_plan_name;