APPS.PAY_PAP_BUS dependencies on PAY_ACCRUAL_PLANS

Line 109: FROM pay_accrual_plans pap

105: l_api_updating BOOLEAN;
106:
107: CURSOR csr_check_name IS
108: SELECT 'Y'
109: FROM pay_accrual_plans pap
110: WHERE UPPER(pap.accrual_plan_name) = UPPER(p_accrual_plan_name)
111: AND pap.business_group_id = p_business_group_id
112: AND ((p_accrual_plan_id is null)
113: OR (p_accrual_plan_id is not null and

Line 1656: pay_accrual_plans b

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: --
1660: -- Declare local variables

Line 1704: (p_accrual_plan_id in pay_accrual_plans.accrual_plan_id%TYPE

1700: -- ----------------------------------------------------------------------------
1701: --
1702: /*
1703: procedure set_security_group_id
1704: (p_accrual_plan_id in pay_accrual_plans.accrual_plan_id%TYPE
1705: ) is
1706: --
1707: -- Declare cursor
1708: --

Line 1712: , pay_accrual_plans pap

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;
1716: --