APPS.PA_PERIODS_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 18: l_imp_period_set_name pa_implementations_all.period_set_name%type;

14: l_org_Id NUMBER := nvl(P_Org_Id, pa_moac_utils.get_current_org_id); -- 12i MOAC changes
15:
16:
17: --Bug 3065754
18: l_imp_period_set_name pa_implementations_all.period_set_name%type;
19:
20: CURSOR NewPeriods
21: IS
22: SELECT

Line 233: PA_IMPLEMENTATIONS_ALL imp,

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)
237: AND prd.org_id = imp.org_id /* Removed the NVL check for bug 6811046*/

Line 254: PA_IMPLEMENTATIONS_ALL imp

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*/
258: AND period_set_name = p_period_set_name --added this condition for the bug 4119508