eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_RESOURCE_UTILS dependencies on PA_CC_ORG_RELATIONSHIPS

Line 500: AND ( EXISTS ( SELECT null FROM PA_CC_ORG_RELATIONSHIPS CO

496: AND RLE.org_information_context (+) = 'Operating Unit Information'
497: AND ( P.org_id = iprv.org_id
498: OR
499: ( PLE.org_information2 = RLE.org_information2
500: AND ( EXISTS ( SELECT null FROM PA_CC_ORG_RELATIONSHIPS CO
501: WHERE CO.prvdr_org_id = iprv.org_id
502: AND CO.recvr_org_id = irecv.org_id
503: AND CO.prvdr_allow_cc_flag = 'Y')
504: OR

Line 507: PA_CC_ORG_RELATIONSHIPS CO

503: AND CO.prvdr_allow_cc_flag = 'Y')
504: OR
505: (iprv.cc_allow_iu_flag = 'Y'
506: AND NOT EXISTS ( SELECT null FROM
507: PA_CC_ORG_RELATIONSHIPS CO
508: WHERE CO.prvdr_org_id = iprv.org_id
509: AND CO.recvr_org_id = irecv.org_id
510: AND CO.prvdr_allow_cc_flag = 'N')
511: )

Line 517: AND EXISTS ( SELECT null FROM PA_CC_ORG_RELATIONSHIPS CO

513: )
514: OR
515: ( PLE.org_information2 <> RLE.org_information2
516: AND PT.project_type_class_code <> 'CAPITAL'
517: AND EXISTS ( SELECT null FROM PA_CC_ORG_RELATIONSHIPS CO
518: WHERE CO.prvdr_org_id = iprv.org_id
519: AND CO.recvr_org_id = irecv.org_id
520: AND CO.prvdr_allow_cc_flag = 'Y'
521: AND (( CO.prvdr_project_id IS NOT NULL