DBA Data[Home] [Help]

APPS.PA_PROJECT_PUB dependencies on PA_WORK_TYPES_VL

Line 10698: pa_work_types_vl pwt,

10694: CURSOR cur_check_work_type(p_project_id IN NUMBER ,p_work_type_id IN NUMBER ) IS
10695: SELECT
10696: 'Y'
10697: FROM
10698: pa_work_types_vl pwt,
10699: pa_projects pp,
10700: pa_project_types ppt
10701: WHERE
10702: trunc(sysdate) BETWEEN pwt.start_date_active AND nvl(pwt.end_date_active,trunc(SYSDATE)) AND