DBA Data[Home] [Help]

APPS.PA_CONTROL_API_PVT dependencies on PA_PROJECT_PARTIES_V

Line 1626: from PA_PROJECT_PARTIES_V

1622: cursor validate_owner_id(p_project_id number, p_owner_id number)
1623: is
1624: select distinct resource_party_id,
1625: resource_source_name
1626: from PA_PROJECT_PARTIES_V
1627: where party_type <> 'ORGANIZATION'
1628: and project_id = p_project_id
1629: and resource_party_id = p_owner_id;
1630:

Line 1674: from PA_PROJECT_PARTIES_V

1670:
1671: cursor validate_cls_by_id(p_project_id number, p_closed_by_id number)
1672: is
1673: select 'Y'
1674: from PA_PROJECT_PARTIES_V
1675: where party_type <> 'ORGANIZATION'
1676: and project_id = p_project_id
1677: and resource_party_id = p_closed_by_id --validating the p_closed_by_id
1678: and pa_ci_security_pkg.check_proj_auth_ci(p_project_id, l_user_id, l_resp_id) = 'T'; --validating the project authority here.