APPS.PA_TXN_ACCUMS dependencies on PA_PROJECTS

Line 1384: PA_PROJECTS_ALL prj,

1380: into
1381: l_cur_pa_period,
1382: l_cur_gl_period
1383: from
1384: PA_PROJECTS_ALL prj,
1385: PA_PERIODS_ALL per
1386: where
1387: prj.PROJECT_ID = x_start_project_id and
1388: nvl(per.ORG_ID, -1) = nvl(prj.ORG_ID, -1) and

Line 3811: (l_project_id pa_projects.project_id%TYPE)

3807: -- This cursor retrives the Project Currency Code for the project.
3808: /* Bug# 2158736 - Included projfunc_currency_code in the cursor */
3809:
3810: CURSOR l_project_curr_code_csr
3811: (l_project_id pa_projects.project_id%TYPE)
3812: IS
3813: SELECT project_currency_code,projfunc_currency_code
3814: FROM pa_projects p
3815: WHERE p.project_id = l_project_id;

Line 3814: FROM pa_projects p

3810: CURSOR l_project_curr_code_csr
3811: (l_project_id pa_projects.project_id%TYPE)
3812: IS
3813: SELECT project_currency_code,projfunc_currency_code
3814: FROM pa_projects p
3815: WHERE p.project_id = l_project_id;
3816:
3817:
3818: --

Line 3824: l_project_curr_code pa_projects.project_currency_code%TYPE := NULL;

3820: --
3821:
3822: -- Procedure Variables
3823: l_proj_curr_OK VARCHAR2(1) := 'Y';
3824: l_project_curr_code pa_projects.project_currency_code%TYPE := NULL;
3825: l_sum_exception_code pa_project_accum_headers.sum_exception_code%TYPE := NULL;
3826:
3827:
3828: -- Main LOOP Variables

Line 3857: l_PROJFUNC_CURR_CODE pa_projects.project_currency_code%TYPE := NULL;

3853:
3854: -- Bug 2119738: New Parameters
3855: l_SYSTEM_LINKAGE pa_expenditure_items_all.SYSTEM_LINKAGE_FUNCTION%TYPE :=NULL;
3856: l_PROJECT_RAW_COST NUMBER := NULL;
3857: l_PROJFUNC_CURR_CODE pa_projects.project_currency_code%TYPE := NULL;
3858: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;
3859: l_PROJFUNC_COST_RATE_DATE DATE := NULL;
3860: l_PROJFUNC_COST_EXCH_RATE NUMBER := NULL;
3861: