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.OKE_K_SECURITY_PKG dependencies on PA_PROJECT_PARTIES

Line 393: FROM pa_project_parties pp

389: /*
390: This version somehow results in FTS
391:
392: SELECT project_role_id
393: FROM pa_project_parties pp
394: , oke_k_headers kh
395: WHERE kh.k_header_id = C_K_Header_ID
396: AND ( ( pp.object_type = 'OKE_K_HEADERS'
397: AND pp.object_id = kh.k_header_id

Line 415: FROM pa_project_parties pp

411: -- site level assignment
412: --
413: SELECT Project_Role_ID
414: , decode(pp.object_type, 'OKE_K_HEADERS', 1, 3) Sort_Order
415: FROM pa_project_parties pp
416: WHERE ( pp.object_type , pp.object_id ) IN
417: ( ( 'OKE_K_HEADERS' , C_K_Header_ID )
418: , ( 'OKE_PROGRAMS' , 0 )
419: )

Line 430: -- results in a FTS of PA_PROJECT_PARTIES.

426: --
427: -- Second part of the union retrieves program level assignment.
428: -- This is separated from the first part because it requires a
429: -- join to OKE_K_HEADERS and for some reason the combined SELECT
430: -- results in a FTS of PA_PROJECT_PARTIES.
431: --
432: SELECT Project_Role_ID
433: , 2
434: FROM pa_project_parties pp

Line 434: FROM pa_project_parties pp

430: -- results in a FTS of PA_PROJECT_PARTIES.
431: --
432: SELECT Project_Role_ID
433: , 2
434: FROM pa_project_parties pp
435: , oke_k_headers kh
436: WHERE kh.k_header_id = C_K_Header_ID
437: AND pp.object_type = 'OKE_PROGRAMS'
438: AND pp.object_id = kh.program_id