DBA Data[Home] [Help]

APPS.PA_COST dependencies on PA_IMPLEMENTATIONS_ALL

Line 1064: pa_implementations_all imp

1060: INTO l_projfunc_rate_date,
1061: l_projfunc_rate_type
1062: FROM pa_projects_all prj,
1063: pa_tasks tsk,
1064: pa_implementations_all imp
1065: WHERE prj.project_id = p_project_id
1066: AND prj.project_id = tsk.project_id
1067: AND tsk.task_id = p_task_id
1068: AND nvl(prj.org_id ,-99) = nvl(imp.org_id,-99)

Line 1088: pa_implementations_all imp

1084: NVL(prj.projfunc_cost_rate_type, imp.default_rate_type)
1085: INTO l_projfunc_rate_date,
1086: l_projfunc_rate_type
1087: FROM pa_projects_all prj,
1088: pa_implementations_all imp
1089: WHERE prj.project_id = p_project_id
1090: AND nvl(prj.org_id,-99) = nvl(imp.org_id,-99)
1091: AND nvl(imp.org_id,-99) = nvl(p_proj_org_id,-99);
1092: EXCEPTION

Line 1582: PA_IMPLEMENTATIONS_ALL IMP

1578: SELECT FC.currency_code
1579: INTO l_currency_code
1580: FROM FND_CURRENCIES FC,
1581: GL_SETS_OF_BOOKS GB,
1582: PA_IMPLEMENTATIONS_ALL IMP
1583: WHERE FC.currency_code = DECODE(imp.set_of_books_id, NULL, NULL, GB.currency_code)
1584: AND GB.set_of_books_id = IMP.set_of_books_id
1585: AND IMP.org_id = p_org_id; --Bug#5903720
1586: