DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on PA_PROJECT_PARTIES_V

Line 1643: from PA_PROJECT_PARTIES_V

1639: cursor validate_owner_id(p_project_id number, p_owner_id number)
1640: is
1641: select distinct resource_party_id,
1642: resource_source_name
1643: from PA_PROJECT_PARTIES_V
1644: where party_type <> 'ORGANIZATION'
1645: and project_id = p_project_id
1646: and resource_party_id = p_owner_id;
1647:

Line 1691: from PA_PROJECT_PARTIES_V

1687:
1688: cursor validate_cls_by_id(p_project_id number, p_closed_by_id number)
1689: is
1690: select 'Y'
1691: from PA_PROJECT_PARTIES_V
1692: where party_type <> 'ORGANIZATION'
1693: and project_id = p_project_id
1694: and resource_party_id = p_closed_by_id --validating the p_closed_by_id
1695: and pa_ci_security_pkg.check_proj_auth_ci(p_project_id, l_user_id, l_resp_id) = 'T'; --validating the project authority here.