APPS.PJI_FM_CMT_EXTR dependencies on PA_PERIODS_ALL

Line 97: PA_PERIODS_ALL per

93: x_pa_period,
94: x_gl_period
95: from
96: PA_PROJECTS_ALL prj,
97: PA_PERIODS_ALL per
98: where
99: prj.PROJECT_ID = x_project_id and
100: nvl(per.ORG_ID, -1) = nvl(prj.ORG_ID, -1) and
101: per.CURRENT_PA_PERIOD_FLAG = 'Y';

Line 693: PA_PERIODS_ALL per

689: nvl(per.ORG_ID, -1) ORG_ID,
690: per.PERIOD_NAME PA_PERIOD,
691: per.GL_PERIOD_NAME GL_PERIOD
692: from
693: PA_PERIODS_ALL per
694: where
695: -- per.CURRENT_PA_PERIOD_FLAG = 'Y' Bug fix 7602463
696: trunc(sysdate) between per.start_date and per.end_date
697: ) per