DBA Data[Home] [Help]

APPS.PA_PERIODS_PKG dependencies on PA_PERIODS_ALL

Line 223: l_period_name pa_periods_all.period_name%TYPE;

219: p_period_set_name IN VARCHAR2)
220: RETURN VARCHAR2 is
221:
222: l_temp varchar2(1);
223: l_period_name pa_periods_all.period_name%TYPE;
224:
225: l_pji_name pji_time_cal_period.NAME%TYPE;
226:
227: l_rec_count NUMBER;

Line 232: FROM PA_PERIODS_ALL prd,

228:
229:
230: CURSOR period_cur IS
231: SELECT period_name
232: FROM PA_PERIODS_ALL prd,
233: PA_IMPLEMENTATIONS_ALL imp,
234: GL_SETS_OF_BOOKS sob
235: WHERE (period_name = p_period_name
236: OR gl_period_name = p_period_name)

Line 253: FROM PA_PERIODS_ALL prd,

249: If period_cur%NOTFOUND Then
250:
251: SELECT COUNT(*)
252: into l_rec_count
253: FROM PA_PERIODS_ALL prd,
254: PA_IMPLEMENTATIONS_ALL imp
255: WHERE ( period_name = p_period_name
256: OR gl_period_name =p_period_name)
257: AND prd.org_id = imp.org_id /* Removed the NVL check for bug 6811046*/