APPS.PA_ACCUM_PROJ_LIST dependencies on PA_PERIODS_ALL

Line 54: l_period_name pa_periods_all.period_name%TYPE := NULL;

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;
58: l_err_stack VARCHAR2(2000) := NULL;

Line 78: FROM pa_periods_all

74:
75: CURSOR currperiod_csr
76: IS
77: SELECT decode(l_accum_period_type, 'GL', GL_PERIOD_NAME, PERIOD_NAME)
78: FROM pa_periods_all
79: WHERE current_pa_period_flag = 'Y'
80: and org_id = g_org_id; /*removed nvl() from nvl(org_id,-99) for bug 6327647*/
81:
82:

Line 397: l_period_name pa_periods_all.period_name%TYPE := NULL;

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;
401: l_err_stack VARCHAR2(2000) := NULL;

Line 423: FROM pa_periods_all

419:
420: CURSOR currperiod_csr
421: IS
422: SELECT decode(l_accum_period_type, 'GL', GL_PERIOD_NAME, PERIOD_NAME)
423: FROM pa_periods_all
424: WHERE current_pa_period_flag = 'Y'
425: and org_id = g_org_id; /*removed nvl() from nvl(org_id,-99) for bug 6327647*/
426:
427: