APPS.PA_TXN_ACCUMS dependencies on PA_PROJECTS

Line 1389: PA_PROJECTS_ALL prj,

1385: into
1386: l_cur_pa_period,
1387: l_cur_gl_period
1388: from
1389: PA_PROJECTS_ALL prj,
1390: PA_PERIODS_ALL per
1391: where
1392: prj.PROJECT_ID = x_start_project_id and
1393: nvl(per.ORG_ID, -1) = nvl(prj.ORG_ID, -1) and

Line 3991: (l_project_id pa_projects.project_id%TYPE)

3987: -- This cursor retrives the Project Currency Code for the project.
3988: /* Bug# 2158736 - Included projfunc_currency_code in the cursor */
3989:
3990: CURSOR l_project_curr_code_csr
3991: (l_project_id pa_projects.project_id%TYPE)
3992: IS
3993: SELECT project_currency_code,projfunc_currency_code
3994: FROM pa_projects p
3995: WHERE p.project_id = l_project_id;

Line 3994: FROM pa_projects p

3990: CURSOR l_project_curr_code_csr
3991: (l_project_id pa_projects.project_id%TYPE)
3992: IS
3993: SELECT project_currency_code,projfunc_currency_code
3994: FROM pa_projects p
3995: WHERE p.project_id = l_project_id;
3996:
3997:
3998: --

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

4000: --
4001:
4002: -- Procedure Variables
4003: l_proj_curr_OK VARCHAR2(1) := 'Y';
4004: l_project_curr_code pa_projects.project_currency_code%TYPE := NULL;
4005: l_sum_exception_code pa_project_accum_headers.sum_exception_code%TYPE := NULL;
4006:
4007:
4008: -- Main LOOP Variables

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

4033:
4034: -- Bug 2119738: New Parameters
4035: l_SYSTEM_LINKAGE pa_expenditure_items_all.SYSTEM_LINKAGE_FUNCTION%TYPE :=NULL;
4036: l_PROJECT_RAW_COST NUMBER := NULL;
4037: l_PROJFUNC_CURR_CODE pa_projects.project_currency_code%TYPE := NULL;
4038: l_PROJFUNC_COST_RATE_TYPE pa_commitment_txns.project_rate_type%TYPE := NULL;
4039: l_PROJFUNC_COST_RATE_DATE DATE := NULL;
4040: l_PROJFUNC_COST_EXCH_RATE NUMBER := NULL;
4041: