DBA Data[Home] [Help]

APPS.GL_PERIOD_STATUSES_PKG dependencies on GL_ACCESS_SET_LEDGERS

Line 96: gl_access_set_ledgers acc

92: led_id NUMBER) RETURN VARCHAR2 IS
93: CURSOR get_latest_opened IS
94: SELECT ps.period_name
95: FROM gl_period_statuses ps,
96: gl_access_set_ledgers acc
97: WHERE ps.application_id = 101
98: AND ps.ledger_id = led_id
99: AND ps.closing_status = 'O'
100: AND acc.access_set_id = acc_id

Line 110: gl_access_set_ledgers acc

106:
107: CURSOR get_earliest_future_ent IS
108: SELECT ps.period_name
109: FROM gl_period_statuses ps,
110: gl_access_set_ledgers acc
111: WHERE ps.application_id = 101
112: AND ps.ledger_id = led_id
113: AND ps.closing_status = 'F'
114: AND acc.access_set_id = acc_id