DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_WORK_TYPES_VL

Line 10436: pa_work_types_vl pwt,

10432: CURSOR cur_check_work_type(p_project_id IN NUMBER ,p_work_type_id IN NUMBER ) IS
10433: SELECT
10434: 'Y'
10435: FROM
10436: pa_work_types_vl pwt,
10437: pa_projects pp,
10438: pa_project_types ppt
10439: WHERE
10440: trunc(sysdate) BETWEEN pwt.start_date_active AND nvl(pwt.end_date_active,trunc(SYSDATE)) AND