DBA Data[Home] [Help]

APPS.PAY_FR_SICKNESS_ABSENCE dependencies on PAY_ACCRUAL_PLANS

Line 362: from pay_accrual_plans pap,

358: -- Cursor to find the accrual plan id
359: -- and absence type
360: Cursor csr_get_accrual_plan is
361: Select pap.accrual_plan_id, pabt.absence_category
362: from pay_accrual_plans pap,
363: per_absence_attendance_types pabt
364: where pabt.absence_attendance_type_id = p_absence_attendance_type_id
365: and pap.pto_input_value_id= pabt.input_value_id;
366: --

Line 480: from pay_accrual_plans pap,

476: Select pap.accrual_plan_id,
477: pabt.absence_category,
478: pabs.person_id,
479: pabt.absence_attendance_type_id
480: from pay_accrual_plans pap,
481: per_absence_attendance_types pabt,
482: per_absence_attendances pabs
483: where pabs.absence_attendance_id = p_absence_attendance_id
484: and pabt.absence_attendance_type_id = pabs.absence_attendance_type_id