APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1864: FROM pa_resource_assignments pra

1860: SELECT COUNT(1)
1861: FROM DUAL
1862: WHERE EXISTS
1863: (SELECT 'X'
1864: FROM pa_resource_assignments pra
1865: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1866: AND pra.project_id = p_project_id
1867: AND pra.project_assignment_id = -1
1868: AND (pra.task_id=c_task_id OR pra.task_id=p_impacted_task_id));*/

Line 1875: FROM pa_resource_assignments pra

1871: SELECT COUNT(1)
1872: FROM DUAL
1873: WHERE EXISTS
1874: (SELECT 'X'
1875: FROM pa_resource_assignments pra
1876: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1877: AND pra.project_id = p_project_id
1878: AND pra.project_assignment_id = -1
1879: AND EXISTS ( SELECT 1

Line 1890: FROM pa_resource_assignments pra

1886: SELECT COUNT(1)
1887: FROM DUAL
1888: WHERE EXISTS
1889: (SELECT 'X'
1890: FROM pa_resource_assignments pra
1891: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1892: AND pra.project_id = p_project_id
1893: AND pra.project_assignment_id = -1
1894: AND (pra.task_id = p_impacted_task_id or pra.task_id = c_top_task_id));-- /*UT*/fe.top_task_id = c_top_task_id)

Line 1902: FROM pa_resource_assignments pra,

1898: SELECT COUNT(1)
1899: FROM DUAL
1900: WHERE EXISTS
1901: (SELECT 'X'
1902: FROM pa_resource_assignments pra,
1903: pa_tasks t
1904: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1905: AND pra.project_id = p_project_id
1906: AND pra.project_assignment_id = -1

Line 1915: FROM pa_resource_assignments pra

1911: SELECT count(1)
1912: FROM DUAL
1913: WHERE EXISTS
1914: (SELECT 'X'
1915: FROM pa_resource_assignments pra
1916: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1917: AND pra.project_id = p_project_id
1918: AND pra.project_assignment_id = -1);
1919: BEGIN

Line 3712: pa_resource_assignments ra

3708: l_target_plan_level := 'R';
3709: l_prj_rlm_id := null;
3710: begin
3711: select ra.resource_list_member_id into l_prj_rlm_id from
3712: pa_resource_assignments ra
3713: where
3714: ra.budget_version_id = p_s_budget_version_id and
3715: nvl(ra.resource_assignment_type,'USER_ENTERED') =
3716: 'USER_ENTERED' and

Line 3731: pa_resource_assignments ra

3727: /* checking for target */
3728: l_prj_rlm_id := null;
3729: begin
3730: select ra.resource_list_member_id into l_prj_rlm_id from
3731: pa_resource_assignments ra
3732: where
3733: ra.budget_version_id = p_t_budget_version_id and
3734: nvl(ra.resource_assignment_type,'USER_ENTERED') =
3735: 'USER_ENTERED' and

Line 3779: pa_resource_assignments ra

3775: if p_t_fin_plan_level_code = 'P' then
3776: l_prj_rlm_id := null;
3777: begin
3778: select ra.resource_list_member_id into l_prj_rlm_id from
3779: pa_resource_assignments ra
3780: where
3781: ra.budget_version_id = p_t_budget_version_id and
3782: nvl(ra.resource_assignment_type,'USER_ENTERED') =
3783: 'USER_ENTERED' and