DBA Data[Home] [Help]

APPS.PA_COST dependencies on PA_IMPLEMENTATIONS_ALL

Line 1097: pa_implementations_all imp

1093: INTO l_projfunc_rate_date,
1094: l_projfunc_rate_type
1095: FROM pa_projects_all prj,
1096: pa_tasks tsk,
1097: pa_implementations_all imp
1098: WHERE prj.project_id = p_project_id
1099: AND prj.project_id = tsk.project_id
1100: AND tsk.task_id = p_task_id
1101: AND nvl(prj.org_id ,-99) = nvl(imp.org_id,-99)

Line 1121: pa_implementations_all imp

1117: NVL(prj.projfunc_cost_rate_type, imp.default_rate_type)
1118: INTO l_projfunc_rate_date,
1119: l_projfunc_rate_type
1120: FROM pa_projects_all prj,
1121: pa_implementations_all imp
1122: WHERE prj.project_id = p_project_id
1123: AND nvl(prj.org_id,-99) = nvl(imp.org_id,-99)
1124: AND nvl(imp.org_id,-99) = nvl(p_proj_org_id,-99);
1125: EXCEPTION

Line 1615: PA_IMPLEMENTATIONS_ALL IMP

1611: SELECT FC.currency_code
1612: INTO l_currency_code
1613: FROM FND_CURRENCIES FC,
1614: GL_SETS_OF_BOOKS GB,
1615: PA_IMPLEMENTATIONS_ALL IMP
1616: WHERE FC.currency_code = DECODE(imp.set_of_books_id, NULL, NULL, GB.currency_code)
1617: AND GB.set_of_books_id = IMP.set_of_books_id
1618: AND IMP.org_id = p_org_id; --Bug#5903720
1619: