APPS.JG_INFO dependencies on GL_PERIOD_STATUSES

Line 13: from gl_period_statuses

9: IS
10: BEGIN
11: select start_date, end_date
12: into tstart_date, tend_date
13: from gl_period_statuses
14: where period_name = tperiod_name
15: and ledger_id = tset_of_books_id -- 11ix
16: and application_id = app_id ;
17: EXCEPTION

Line 110: FROM gl_period_statuses a, gl_period_statuses b

106: IS
107: BEGIN
108: SELECT a.period_name
109: INTO tfirst_period
110: FROM gl_period_statuses a, gl_period_statuses b
111: WHERE a.application_id = app_id
112: AND b.application_id = app_id
113: AND a.ledger_id = tset_of_books_id -- 11ix
114: AND b.ledger_id = tset_of_books_id -- 11ix

Line 120: FROM gl_period_statuses c

116: AND a.period_year = b.period_year
117: AND b.period_name = tperiod_name
118: AND a.period_num =
119: (SELECT min(c.period_num)
120: FROM gl_period_statuses c
121: WHERE c.application_id = app_id
122: AND c.ledger_id = tset_of_books_id -- 11ix
123: AND c.period_year = a.period_year
124: AND c.period_type = a.period_type

Line 144: FROM gl_period_statuses a, gl_period_statuses b

140: IS
141: BEGIN
142: SELECT a.period_name
143: INTO tfirst_period
144: FROM gl_period_statuses a, gl_period_statuses b
145: WHERE a.application_id = app_id
146: AND b.application_id = app_id
147: AND a.ledger_id = tset_of_books_id -- 11ix
148: AND b.ledger_id = tset_of_books_id -- 11ix

Line 155: FROM gl_period_statuses c

151: AND a.quarter_num = b.quarter_num
152: AND b.period_name = tperiod_name
153: AND a.period_num =
154: (SELECT min(c.period_num)
155: FROM gl_period_statuses c
156: WHERE c.application_id = app_id
157: AND c.ledger_id = tset_of_books_id -- 11ix
158: AND c.period_year = a.period_year
159: AND c.quarter_num = a.quarter_num