DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on PA_CI_TYPES_VL

Line 1280: from pa_ci_types_vl

1276: /*pa_ci_security_pkg.check_create_ci will check if the current project type and role played by user are allowed
1277: to create the control item of this type. Also it will check for project authority.*/
1278: cursor check_create_ci_priv(p_ci_type_id NUMBER, p_project_id NUMBER) is
1279: select 'Y'
1280: from pa_ci_types_vl
1281: where ci_type_id = p_ci_type_id
1282: and pa_ci_security_pkg.check_create_ci(p_ci_type_id, p_project_id)='T'
1283: and trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate);
1284: