APPS.PA_PERIOD_PROCESS_PKG dependencies on PA_IMPLEMENTATIONS

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 113: and b.set_of_books_id = (select set_of_books_id from pa_implementations)

109: b.last_update_date, b.last_updated_by, b.last_update_login /* added bug 3111150 */
110: from pa_periods a, gl_period_statuses b
111: where a.period_name = b.period_name
112: and b.application_id = 8721
113: and b.set_of_books_id = (select set_of_books_id from pa_implementations)
114: and a.start_date = b.start_date
115: and a.end_Date = b.end_date
116: and a.status <> b.closing_status;
117:

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;