DBA Data[Home] [Help]

APPS.PAY_NZ_HOLIDAYS_2003 dependencies on PAY_ACCRUAL_BANDS

Line 1241: from pay_accrual_bands bnd

1237: ,p_accrual_plan_id number
1238: ) is
1239: select bnd.annual_rate annual_rate
1240: , acc.accrual_units_of_measure uom
1241: from pay_accrual_bands bnd
1242: , pay_accrual_plans acc
1243: where p_number_of_years >= bnd.lower_limit
1244: and p_number_of_years < bnd.upper_limit
1245: and bnd.accrual_plan_id = p_accrual_plan_id