APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1830: FROM pa_resource_assignments pra

1826: SELECT COUNT(1)
1827: FROM DUAL
1828: WHERE EXISTS
1829: (SELECT 'X'
1830: FROM pa_resource_assignments pra
1831: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1832: AND pra.project_id = p_project_id
1833: AND pra.project_assignment_id = -1
1834: AND (pra.task_id=c_task_id OR pra.task_id=p_impacted_task_id));*/

Line 1841: FROM pa_resource_assignments pra

1837: SELECT COUNT(1)
1838: FROM DUAL
1839: WHERE EXISTS
1840: (SELECT 'X'
1841: FROM pa_resource_assignments pra
1842: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1843: AND pra.project_id = p_project_id
1844: AND pra.project_assignment_id = -1
1845: AND EXISTS ( SELECT 1

Line 1856: FROM pa_resource_assignments pra

1852: SELECT COUNT(1)
1853: FROM DUAL
1854: WHERE EXISTS
1855: (SELECT 'X'
1856: FROM pa_resource_assignments pra
1857: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1858: AND pra.project_id = p_project_id
1859: AND pra.project_assignment_id = -1
1860: 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 1868: FROM pa_resource_assignments pra,

1864: SELECT COUNT(1)
1865: FROM DUAL
1866: WHERE EXISTS
1867: (SELECT 'X'
1868: FROM pa_resource_assignments pra,
1869: pa_tasks t
1870: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1871: AND pra.project_id = p_project_id
1872: AND pra.project_assignment_id = -1

Line 1881: FROM pa_resource_assignments pra

1877: SELECT count(1)
1878: FROM DUAL
1879: WHERE EXISTS
1880: (SELECT 'X'
1881: FROM pa_resource_assignments pra
1882: WHERE pra.budget_version_id = l_ci_apprv_cw_bv_id
1883: AND pra.project_id = p_project_id
1884: AND pra.project_assignment_id = -1);
1885: BEGIN

Line 3663: pa_resource_assignments ra

3659: l_target_plan_level := 'R';
3660: l_prj_rlm_id := null;
3661: begin
3662: select ra.resource_list_member_id into l_prj_rlm_id from
3663: pa_resource_assignments ra
3664: where
3665: ra.budget_version_id = p_s_budget_version_id and
3666: nvl(ra.resource_assignment_type,'USER_ENTERED') =
3667: 'USER_ENTERED' and

Line 3682: pa_resource_assignments ra

3678: /* checking for target */
3679: l_prj_rlm_id := null;
3680: begin
3681: select ra.resource_list_member_id into l_prj_rlm_id from
3682: pa_resource_assignments ra
3683: where
3684: ra.budget_version_id = p_t_budget_version_id and
3685: nvl(ra.resource_assignment_type,'USER_ENTERED') =
3686: 'USER_ENTERED' and

Line 3730: pa_resource_assignments ra

3726: if p_t_fin_plan_level_code = 'P' then
3727: l_prj_rlm_id := null;
3728: begin
3729: select ra.resource_list_member_id into l_prj_rlm_id from
3730: pa_resource_assignments ra
3731: where
3732: ra.budget_version_id = p_t_budget_version_id and
3733: nvl(ra.resource_assignment_type,'USER_ENTERED') =
3734: 'USER_ENTERED' and