APPS.HR_PTO_VIEWS dependencies on PAY_ACCRUAL_PLANS

Line 287: ,pay_accrual_plans plan

283: ,paf.business_group_id, paf.payroll_id
284: ,ee.element_entry_id, ee.effective_start_date ee_start_date
285: from pay_element_entries_f ee
286: ,pay_element_types_f et
287: ,pay_accrual_plans plan
288: ,per_all_assignments_f paf
289: ,per_all_people_f peo
290: ,hr_lookups lookup
291: where peo.person_id = cp_person_id

Line 360: from pay_accrual_plans

356: ,p_plan_id number) RETURN NUMBER IS
357: --
358: cursor csr_get_balance is
359: select defined_balance_id
360: from pay_accrual_plans
361: where accrual_plan_id = p_plan_id;
362: --
363: l_asg_rec csr_get_aaid_details%ROWTYPE;
364: l_balance_id pay_accrual_plans.defined_balance_id%TYPE;

Line 364: l_balance_id pay_accrual_plans.defined_balance_id%TYPE;

360: from pay_accrual_plans
361: where accrual_plan_id = p_plan_id;
362: --
363: l_asg_rec csr_get_aaid_details%ROWTYPE;
364: l_balance_id pay_accrual_plans.defined_balance_id%TYPE;
365: l_result number;
366: l_date date;
367: --
368: BEGIN