DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on PA_CROSS_BUSINESS_GRP

Line 483: and pa_cross_business_grp.IsCrossBGProfile='N')

479: WHERE P.project_type = PT.project_type
480: AND NVL(P.template_flag, 'N') <> 'Y'
481: --Bug2538692 AND pa_security.allow_query(P.project_id) = 'Y'
482: AND ((iprv.business_group_id = irecv.business_group_id
483: and pa_cross_business_grp.IsCrossBGProfile='N')
484: OR pa_cross_business_grp.IsCrossBGProfile ='Y')
485: AND (irecv.org_id IS NULL OR irecv.org_id = P.org_id)
486: AND (PT.org_id IS NULL or PT.org_id = P.org_id)
487: AND PT.project_type <> 'AWARD_PROJECT'

Line 484: OR pa_cross_business_grp.IsCrossBGProfile ='Y')

480: AND NVL(P.template_flag, 'N') <> 'Y'
481: --Bug2538692 AND pa_security.allow_query(P.project_id) = 'Y'
482: AND ((iprv.business_group_id = irecv.business_group_id
483: and pa_cross_business_grp.IsCrossBGProfile='N')
484: OR pa_cross_business_grp.IsCrossBGProfile ='Y')
485: AND (irecv.org_id IS NULL OR irecv.org_id = P.org_id)
486: AND (PT.org_id IS NULL or PT.org_id = P.org_id)
487: AND PT.project_type <> 'AWARD_PROJECT'
488: AND nvl(PT.cc_prvdr_flag, 'N') <> 'Y'