DBA Data[Home] [Help]

APPS.PA_FP_CALC_UTILS dependencies on GL_PERIODS

Line 4270: FROM gl_periods gp

4266: WHERE ra.budget_version_id = p_budget_verson_id
4267: AND ra.resource_assignment_id = tmp.resource_assignment_id
4268: AND NOT EXISTS
4269: (SELECT 'No period exist'
4270: FROM gl_periods gp
4271: WHERE gp.period_set_name = periodDetailsRec.period_set_name
4272: AND gp.period_type = decode(p_time_phase_code,'G',periodDetailsRec.accounted_period_type
4273: ,'P',periodDetailsRec.pa_period_type)
4274: AND gp.adjustment_period_flag = 'N'

Line 5456: FROM gl_periods glp1

5452: , g_Rspd_Pjcur_tab(i)
5453: , g_Rspd_Pjf_cur_tab(i)
5454: , null
5455: ,NVL(g_Rspd_SdShrk_Flg_tab(i),'N')
5456: FROM gl_periods glp1
5457: WHERE glp1.adjustment_period_flag = 'N'
5458: AND glp1.period_set_name = perdRec.period_set_name
5459: AND glp1.period_type = l_period_type
5460: AND trunc(g_Rspd_SD_new_tab(i)) BETWEEN glp1.start_date and glp1.end_date

Line 5508: FROM gl_periods glp1

5504: , g_Rspd_Pjcur_tab(i)
5505: , g_Rspd_Pjf_cur_tab(i)
5506: , null
5507: , NVL(g_Rspd_EdShrk_Flg_tab(i),'N')
5508: FROM gl_periods glp1
5509: WHERE glp1.adjustment_period_flag = 'N'
5510: AND glp1.period_set_name = perdRec.period_set_name
5511: AND glp1.period_type = l_period_type
5512: AND trunc(g_Rspd_ED_new_tab(i)) BETWEEN glp1.start_date and glp1.end_date