APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on PAY_ACCRUAL_PLANS

Line 2627: pay_accrual_plans pap,

2623: asg.business_group_id
2624: from pay_element_entry_values_f pev,
2625: pay_element_entries_f pee,
2626: pay_input_values_f piv,
2627: pay_accrual_plans pap,
2628: per_absence_attendance_types abst,
2629: per_all_assignments_f asg
2630: where pee.assignment_id = p_ass_id
2631: and abst.absence_attendance_type_id = p_abs_att_type_id

Line 2642: l_plan_id pay_accrual_plans.accrual_plan_id%TYPE;

2638: and p_calculation_date between pee.effective_start_date
2639: and pee.effective_end_date
2640: and p_calculation_date between asg.effective_start_date and asg.effective_end_date; -- Fix for the bug 9715011
2641:
2642: l_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
2643: l_plan_category pay_accrual_plans.accrual_category%TYPE;
2644: l_units_of_measure pay_accrual_plans.accrual_units_of_measure%TYPE;
2645: l_payroll_id number;
2646: l_business_group_id number;

Line 2643: l_plan_category pay_accrual_plans.accrual_category%TYPE;

2639: and pee.effective_end_date
2640: and p_calculation_date between asg.effective_start_date and asg.effective_end_date; -- Fix for the bug 9715011
2641:
2642: l_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
2643: l_plan_category pay_accrual_plans.accrual_category%TYPE;
2644: l_units_of_measure pay_accrual_plans.accrual_units_of_measure%TYPE;
2645: l_payroll_id number;
2646: l_business_group_id number;
2647: l_entitlement NUMBER;

Line 2644: l_units_of_measure pay_accrual_plans.accrual_units_of_measure%TYPE;

2640: and p_calculation_date between asg.effective_start_date and asg.effective_end_date; -- Fix for the bug 9715011
2641:
2642: l_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
2643: l_plan_category pay_accrual_plans.accrual_category%TYPE;
2644: l_units_of_measure pay_accrual_plans.accrual_units_of_measure%TYPE;
2645: l_payroll_id number;
2646: l_business_group_id number;
2647: l_entitlement NUMBER;
2648: l_start_date date;