DBA Data[Home] [Help]

APPS.OKE_K_APPROVAL_WF2 dependencies on PA_PROJECT_ROLE_TYPES

Line 121: , pa_project_role_types pr

117: from fnd_lookup_values
118: where view_application_id = 777
119: and lookup_type = 'APPROVAL_ACTION'
120: and language = userenv('LANG') ) ac
121: , pa_project_role_types pr
122: WHERE ah.k_header_id = C_Header_ID
123: AND ah.chg_request_id IS NULL
124: AND ac.action_code = ah.action_code
125: AND pr.project_role_id (+) = ah.approver_role_id