DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on PA_CI_TYPES_VL

Line 1263: from pa_ci_types_vl

1259: /*pa_ci_security_pkg.check_create_ci will check if the current project type and role played by user are allowed
1260: to create the control item of this type. Also it will check for project authority.*/
1261: cursor check_create_ci_priv(p_ci_type_id NUMBER, p_project_id NUMBER) is
1262: select 'Y'
1263: from pa_ci_types_vl
1264: where ci_type_id = p_ci_type_id
1265: and pa_ci_security_pkg.check_create_ci(p_ci_type_id, p_project_id)='T'
1266: and trunc(sysdate) between start_date_active and nvl(end_date_active, sysdate);
1267: