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 3086: FROM pa_organizations_event_v

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