DBA Data[Home] [Help]

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_PROJECT_ROLE_TYPES_VL

Line 82: FROM pa_project_role_types_vl role

78: WHEN NO_DATA_FOUND THEN
79: BEGIN
80: IF p_project_role_id is not null then
81: SELECT default_job_id into x_job_id
82: FROM pa_project_role_types_vl role
83: WHERE role.project_role_id = p_project_role_id
84: AND ROWNUM = 1;
85: END IF;
86: EXCEPTION