APPS.GL_XML_JOURNAL_RPT_PKG dependencies on GL_PERIOD_STATUSES

Line 15: FROM gl_period_statuses gps

11: BEGIN
12:
13: SELECT start_date, period_name
14: INTO start_period_date,l_period_name
15: FROM gl_period_statuses gps
16: WHERE gps.application_id = 101
17: AND gps.ledger_id = x_ledger_id
18: AND x_start_date between gps.START_DATE and gps.END_DATE
19: AND gps.adjustment_period_flag <> 'Y';

Line 26: -- start date which does not exists in gl_period_statuses.

22: X_PERIOD_START_DATE := START_PERIOD_DATE;
23: X_START_PERIOD_NAME := l_period_name;
24:
25: -- Add exception block to avoid error when user enters
26: -- start date which does not exists in gl_period_statuses.
27: -- See bug #259063.
28:
29: EXCEPTION
30: WHEN NO_DATA_FOUND THEN

Line 34: FROM gl_period_statuses p1

30: WHEN NO_DATA_FOUND THEN
31:
32: SELECT p1.start_date, p1.period_name
33: INTO start_period_date, l_period_name
34: FROM gl_period_statuses p1
35: WHERE p1.application_id = 101
36: AND p1.ledger_id = x_ledger_id
37: AND p1.adjustment_period_flag <> 'Y'
38: AND p1.start_date =

Line 40: FROM gl_period_statuses p2

36: AND p1.ledger_id = x_ledger_id
37: AND p1.adjustment_period_flag <> 'Y'
38: AND p1.start_date =
39: (SELECT MIN(p2.start_date)
40: FROM gl_period_statuses p2
41: WHERE p2.application_id = 101
42: AND p2.ledger_id = x_ledger_id
43: AND p2.adjustment_period_flag <> 'Y');
44: