APPS.PA_CI_SECURITY_PKG dependencies on PA_PROJECT_PARTIES

Line 776: pa_project_parties p

772: SELECT 1
773: INTO l_tmp
774: FROM pa_object_dist_lists l,
775: pa_dist_list_items i,
776: pa_project_parties p
777: WHERE l.object_type = 'PA_CI_TYPES'
778: AND l.object_id = p_ci_type_id
779: AND i.list_id = l.list_id
780: AND p.project_id = p_project_id

Line 814: from PA_PROJECT_PARTIES_V

810: l_owner_id NUMBER;
811:
812: cursor c_owner (p_project_id NUMBER) is
813: select distinct resource_party_id
814: from PA_PROJECT_PARTIES_V
815: where party_type <> 'ORGANIZATION'
816: and project_id = p_project_id
817: and resource_party_id = p_owner_id;
818: