APPS.PA_UBR_UER_SUMM_PKG dependencies on GL_PERIOD_STATUSES

Line 66: FROM gl_period_statuses gl1,

62: INTO
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

Line 1298: from gl_period_statuses

1294: into
1295: G_gl_period_name,
1296: G_gl_start_date,
1297: G_gl_end_date
1298: from gl_period_statuses
1299: where p_gl_date between START_DATE and END_DATE
1300: and adjustment_period_flag = 'N'
1301: and application_id = p_application_id
1302: and set_of_books_id = p_set_of_books_id;

Line 1341: from gl_period_statuses

1337: into
1338: G_gl_period_name,
1339: G_gl_start_date,
1340: G_gl_end_date
1341: from gl_period_statuses
1342: where p_gl_date between START_DATE and END_DATE
1343: and adjustment_period_flag = 'N'
1344: and application_id = 101 /* GL */
1345: and set_of_books_id = G_set_of_books_id;

Line 1376: from gl_period_statuses

1372: into
1373: G_gl_period_name,
1374: G_gl_start_date,
1375: G_gl_end_date
1376: from gl_period_statuses
1377: where period_name = p_gl_period_name
1378: and application_id = p_application_id
1379: and set_of_books_id = p_set_of_books_id;
1380:

Line 1399: from gl_period_statuses gl1 ,

1395: select
1396: to_char(gl1.start_date,'DD-MON-RR')
1397: into
1398: l_gl_start_date
1399: from gl_period_statuses gl1 ,
1400: pa_implementations imp1
1401: where gl1.period_name = p_gl_period_name
1402: and gl1.application_id = 101
1403: and gl1.set_of_books_id = imp1.set_of_books_id;