APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on PAY_ACCRUAL_PLANS

Line 2523: pay_accrual_plans pap,

2519: asg.business_group_id
2520: from pay_element_entry_values_f pev,
2521: pay_element_entries_f pee,
2522: pay_input_values_f piv,
2523: pay_accrual_plans pap,
2524: per_absence_attendance_types abst,
2525: per_all_assignments_f asg
2526: where pee.assignment_id = p_ass_id
2527: and abst.absence_attendance_type_id = p_abs_att_type_id

Line 2537: l_plan_id pay_accrual_plans.accrual_plan_id%TYPE;

2533: and asg.assignment_id = pee.assignment_id
2534: and p_calculation_date between pee.effective_start_date
2535: and pee.effective_end_date;
2536:
2537: l_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
2538: l_plan_category pay_accrual_plans.accrual_category%TYPE;
2539: l_units_of_measure pay_accrual_plans.accrual_units_of_measure%TYPE;
2540: l_payroll_id number;
2541: l_business_group_id number;

Line 2538: l_plan_category pay_accrual_plans.accrual_category%TYPE;

2534: and p_calculation_date between pee.effective_start_date
2535: and pee.effective_end_date;
2536:
2537: l_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
2538: l_plan_category pay_accrual_plans.accrual_category%TYPE;
2539: l_units_of_measure pay_accrual_plans.accrual_units_of_measure%TYPE;
2540: l_payroll_id number;
2541: l_business_group_id number;
2542: l_entitlement NUMBER;

Line 2539: l_units_of_measure pay_accrual_plans.accrual_units_of_measure%TYPE;

2535: and pee.effective_end_date;
2536:
2537: l_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
2538: l_plan_category pay_accrual_plans.accrual_category%TYPE;
2539: l_units_of_measure pay_accrual_plans.accrual_units_of_measure%TYPE;
2540: l_payroll_id number;
2541: l_business_group_id number;
2542: l_entitlement NUMBER;
2543: l_start_date date;