APPS.PA_UBR_UER_SUMM_PKG dependencies on PA_IMPLEMENTATIONS_ALL

Line 17: from pa_implementations_all all1

13: p_gl_period_name in varchar2 ,
14: p_request_id in number ) IS
15: CURSOR org_cv IS
16: /* select all1.org_id
17: from pa_implementations_all all1
18: where all1.set_of_books_id = ( select s1.set_of_books_id
19: from pa_implementations s1); */
20: /* commented the above and added below for bug 10401877 */
21: select org_id from pa_implementations;

Line 69: pa_implementations_all imp1,

65: G_p_gl_end_date ,
66: G_coa_id ,
67: G_sob
68: FROM gl_period_statuses gl1,
69: pa_implementations_all imp1,
70: gl_sets_of_books sob1
71: WHERE
72: imp1.org_id = p_org_id
73: AND imp1.set_of_books_id = gl1.set_of_books_id

Line 1323: from pa_implementations_all

1319: G_gl_period_name := null;
1320:
1321: select set_of_books_id
1322: into G_set_of_books_id
1323: from pa_implementations_all
1324: where nvl(org_id,-1) = nvl(p_org_id,-1);
1325:
1326: end if;
1327: