DBA Data[Home] [Help]

APPS.PA_BILLING_SCHEDULE_UTILS dependencies on PA_LABOR_MULTIPLIERS

Line 695: FROM pa_labor_multipliers

691:
692: CURSOR cur_lbr_mult
693: IS
694: SELECT 'x'
695: FROM pa_labor_multipliers
696: WHERE project_id = p_project_id
697: AND NVL( TASK_ID, -1 ) = DECODE( p_task_id, NULL, -1, p_task_id )
698: AND (p_effective_from_date BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, p_effective_from_date + 1)
699: OR p_effective_to_date BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE, p_effective_to_date + 1)