DBA Data[Home] [Help]

APPS.PA_ACTIONS_PUB dependencies on PA_ORGANIZATIONS_EVENT_V

Line 3054: l_organization_name pa_organizations_event_v.name%TYPE;

3050: l_project_number pa_projects_all.segment1%TYPE;
3051: l_deliverable_number pa_proj_elements.element_number%TYPE;
3052: l_action_id pa_proj_elements.proj_element_id%TYPE;
3053: l_org_id PA_PROJECTS_ALL.ORG_ID%TYPE;
3054: l_organization_name pa_organizations_event_v.name%TYPE;
3055: l_projfunc_currency_code PA_PROJECTS_ALL.PROJFUNC_CURRENCY_CODE%TYPE;
3056: l_action_owner_id NUMBER; /* Bug # 3590235 */
3057: l_item_dlv VARCHAR2(1);
3058: l_action VARCHAR2(30);

Line 3085: FROM pa_organizations_event_v

3081: AND elem.object_type = 'PA_DELIVERABLES';
3082:
3083: CURSOR C_org_name (p_org_id IN NUMBER) IS
3084: SELECT name
3085: FROM pa_organizations_event_v
3086: WHERE organization_id = P_org_id
3087: AND TRUNC(SYSDATE) BETWEEN date_from AND nvl(date_to, TRUNC(SYSDATE));
3088:
3089: -- 3651489 added cursor to retrieve actions' element version id