APPS.PA_ACCUM_PROJ_LIST dependencies on PA_IMPLEMENTATIONS_ALL

Line 53: l_accum_period_type pa_implementations_all.accumulation_period_type%TYPE := NULL;

49:
50: l_api_name CONSTANT VARCHAR2(30) := 'Insert_Accum';
51: l_project_id NUMBER := 0;
52: l_project_accum_id pa_project_accum_headers.project_accum_id%TYPE := 0;
53: l_accum_period_type pa_implementations_all.accumulation_period_type%TYPE := NULL;
54: l_period_name pa_periods_all.period_name%TYPE := NULL;
55:
56: l_err_code NUMBER := 0;
57: l_err_stage VARCHAR2(2000) := NULL;

Line 72: FROM pa_implementations_all

68:
69: CURSOR periodtype_csr
70: IS
71: SELECT accumulation_period_type
72: FROM pa_implementations_all
73: where org_id = g_org_id; /*removed nvl() from nvl(org_id,-99) for bug 6327647*/
74:
75: CURSOR currperiod_csr
76: IS

Line 396: l_accum_period_type pa_implementations_all.accumulation_period_type%TYPE := NULL;

392:
393: l_api_name CONSTANT VARCHAR2(30) := 'Upgrade_Accum';
394: l_project_id NUMBER := 0;
395: l_project_accum_id pa_project_accum_headers.project_accum_id%TYPE := 0;
396: l_accum_period_type pa_implementations_all.accumulation_period_type%TYPE := NULL;
397: l_period_name pa_periods_all.period_name%TYPE := NULL;
398:
399: l_err_code NUMBER := 0;
400: l_err_stage VARCHAR2(2000) := NULL;

Line 415: FROM pa_implementations_all

411:
412: CURSOR periodtype_csr
413: IS
414: SELECT accumulation_period_type
415: FROM pa_implementations_all
416: where org_id = g_org_id; /*removed nvl() from nvl(org_id,-99) for bug 6327647*/
417:
418:
419: