DBA Data[Home] [Help]

APPS.PA_FP_CALC_PLAN_PKG dependencies on GL_PERIODS

Line 4879: from gl_periods gp

4875: g_stage :='Update_rollupTmp_OvrRates:101';
4876: --print_msg('Update rollup tmp period name where it is null');
4877: UPDATE pa_fp_rollup_tmp tmp
4878: SET tmp.period_name = (select gp.period_name
4879: from gl_periods gp
4880: where gp.period_set_name = perdRec.period_set_name
4881: and gp.adjustment_period_flag = 'N'
4882: and gp.period_type = decode(perdRec.time_phase_code,'G',perdRec.accounted_period_type
4883: ,'P',perdRec.pa_period_type,gp.period_type)