DBA Data[Home] [Help]

APPS.PA_RESOURCE_UTILS dependencies on PA_CROSS_BUSINESS_GRP

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

480: WHERE P.project_type = PT.project_type
481: AND NVL(P.template_flag, 'N') <> 'Y'
482: --Bug2538692 AND pa_security.allow_query(P.project_id) = 'Y'
483: AND ((iprv.business_group_id = irecv.business_group_id
484: and pa_cross_business_grp.IsCrossBGProfile='N')
485: OR pa_cross_business_grp.IsCrossBGProfile ='Y')
486: -- bug 8967761 .. below 2 are changed to remove IS NULL
487: --AND (irecv.org_id IS NULL OR irecv.org_id = P.org_id)
488: --AND (PT.org_id IS NULL or PT.org_id = P.org_id)

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

481: AND NVL(P.template_flag, 'N') <> 'Y'
482: --Bug2538692 AND pa_security.allow_query(P.project_id) = 'Y'
483: AND ((iprv.business_group_id = irecv.business_group_id
484: and pa_cross_business_grp.IsCrossBGProfile='N')
485: OR pa_cross_business_grp.IsCrossBGProfile ='Y')
486: -- bug 8967761 .. below 2 are changed to remove IS NULL
487: --AND (irecv.org_id IS NULL OR irecv.org_id = P.org_id)
488: --AND (PT.org_id IS NULL or PT.org_id = P.org_id)
489: AND (irecv.org_id = P.org_id)