DBA Data[Home] [Help]

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:
21: begin

Line 67: pa_implementations_all imp1,

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

Line 1321: from pa_implementations_all

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