DBA Data[Home] [Help]

APPS.PA_FP_CALC_PLAN_PKG dependencies on GL_PERIODS

Line 4844: from gl_periods gp

4840: g_stage :='Update_rollupTmp_OvrRates:101';
4841: --print_msg('Update rollup tmp period name where it is null');
4842: UPDATE pa_fp_rollup_tmp tmp
4843: SET tmp.period_name = (select gp.period_name
4844: from gl_periods gp
4845: where gp.period_set_name = perdRec.period_set_name
4846: and gp.adjustment_period_flag = 'N'
4847: and gp.period_type = decode(perdRec.time_phase_code,'G',perdRec.accounted_period_type
4848: ,'P',perdRec.pa_period_type,gp.period_type)