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 118: FROM pay_accrual_plans

114: pap.accrual_plan_id <> p_accrual_plan_id));
115:
116: CURSOR check_dup_tl IS
117: SELECT 'Y'
118: FROM pay_accrual_plans
119: WHERE business_group_id = p_business_group_id
120: AND accrual_plan_id =
121: (
122: SELECT DISTINCT accrual_plan_id

Line 123: FROM pay_accrual_plans_tl

119: WHERE business_group_id = p_business_group_id
120: AND accrual_plan_id =
121: (
122: SELECT DISTINCT accrual_plan_id
123: FROM pay_accrual_plans_tl
124: WHERE accrual_plan_name = p_accrual_plan_name
125: AND (
126: p_accrual_plan_id IS NULL
127: OR p_accrual_plan_id <> accrual_plan_id

Line 1680: pay_accrual_plans b

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

Line 1728: (p_accrual_plan_id in pay_accrual_plans.accrual_plan_id%TYPE

1724: -- ----------------------------------------------------------------------------
1725: --
1726: /*
1727: procedure set_security_group_id
1728: (p_accrual_plan_id in pay_accrual_plans.accrual_plan_id%TYPE
1729: ) is
1730: --
1731: -- Declare cursor
1732: --

Line 1736: , pay_accrual_plans pap

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