DBA Data[Home] [Help]

APPS.PA_CI_SECURITY_PKG dependencies on PA_PROJECT_PARTIES

Line 747: pa_project_parties p

743: SELECT 1
744: INTO l_tmp
745: FROM pa_object_dist_lists l,
746: pa_dist_list_items i,
747: pa_project_parties p
748: WHERE l.object_type = 'PA_CI_TYPES'
749: AND l.object_id = p_ci_type_id
750: AND i.list_id = l.list_id
751: AND p.project_id = p_project_id

Line 783: from PA_PROJECT_PARTIES_V

779: l_owner_id NUMBER;
780:
781: cursor c_owner (p_project_id NUMBER) is
782: select distinct resource_party_id
783: from PA_PROJECT_PARTIES_V
784: where party_type <> 'ORGANIZATION'
785: and project_id = p_project_id
786: and resource_party_id = p_owner_id;
787: