APPS.PA_PERIOD_PROCESS_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 67: FUNCTION Use_Same_PA_GL_Period(p_org_id IN pa_implementations_all.org_id%TYPE) RETURN VARCHAR2 IS

63: -- Bug#2103722
64: -- Added new parameter p_org_id and necessary join.
65: --
66:
67: FUNCTION Use_Same_PA_GL_Period(p_org_id IN pa_implementations_all.org_id%TYPE) RETURN VARCHAR2 IS
68: l_return_value VARCHAR(30);
69: BEGIN
70:
71: If G_PrevOrgId = nvl(p_org_id,-99) Then

Line 79: from pa_implementations_all imp

75: Else
76:
77: select nvl(imp.same_pa_gl_period,'N')
78: into l_return_value
79: from pa_implementations_all imp
80: where imp.org_id = nvl(p_org_id, -99); /*5368274*/
81:
82: G_PrevOrgId := nvl(p_org_id,-99);
83: G_PrevRetValue := l_return_value;

Line 156: from pa_implementations_all imp

152: pp.last_updated_by = l_LastUpdatedBy(i), /* added bug 3111150 */
153: pp.last_update_login = l_LastUpdateLogin(i) /* added bug 3111150 */
154: where pp.period_name = l_PeriodTab(i)
155: and pp.org_id in (select imp.org_id
156: from pa_implementations_all imp
157: where nvl(imp.same_pa_gl_period,'N') = 'Y'
158: and imp.set_of_books_id = l_SobId(i));
159:
160: commit;