APPS.PA_ASSIGNMENT_UTILS dependencies on PA_IMPLEMENTATIONS

Line 153: --BUG: 1904822 Get project business group id instead of from pa_implementations

149: ELSE
150: CLOSE l_bg_csr;
151: END IF;
152:
153: --BUG: 1904822 Get project business group id instead of from pa_implementations
154: IF ( l_comp_bg_id IS NOT NULL
155: AND l_comp_bg_id <> pa_project_utils2.Get_project_business_group ( p_project_id)) THEN
156: x_return_status := FND_API.G_RET_STS_ERROR;
157: x_error_message_code := 'PA_ASGMT_COMPETENCY_INVALID';

Line 1861: from pa_implementations where rownum = 1;

1857: l_proj_imp_flag VARCHAR2(1) := 'N';
1858:
1859: Cursor c_imp_ous IS
1860: select org_id
1861: from pa_implementations where rownum = 1;
1862:
1863: Cursor c_check_proj_imp(p_org_id NUMBER ) IS
1864: select 'Y'
1865: from pa_implementations

Line 1865: from pa_implementations

1861: from pa_implementations where rownum = 1;
1862:
1863: Cursor c_check_proj_imp(p_org_id NUMBER ) IS
1864: select 'Y'
1865: from pa_implementations
1866: where org_id = p_org_id ;
1867:
1868: l_ou_id hr_operating_units.organization_id%TYPE;
1869: