DBA Data[Home] [Help]

APPS.RCV_CREATEACCOUNTING_PVT dependencies on GL_PERIOD_STATUSES

Line 113: FROM gl_period_statuses GL_PER,

109:
110: BEGIN
111: SELECT GL_PER.period_name
112: INTO x_gl_information.period_name
113: FROM gl_period_statuses GL_PER,
114: gl_period_statuses PO_PER
115: WHERE PO_PER.application_id = G_PO_APPLICATION_ID
116: AND PO_PER.set_of_books_id = p_set_of_books_id
117: AND trunc(PO_PER.start_date) <= trunc(p_event_date)

Line 114: gl_period_statuses PO_PER

110: BEGIN
111: SELECT GL_PER.period_name
112: INTO x_gl_information.period_name
113: FROM gl_period_statuses GL_PER,
114: gl_period_statuses PO_PER
115: WHERE PO_PER.application_id = G_PO_APPLICATION_ID
116: AND PO_PER.set_of_books_id = p_set_of_books_id
117: AND trunc(PO_PER.start_date) <= trunc(p_event_date)
118: AND trunc(PO_PER.end_date) >= trunc(p_event_date)

Line 139: FROM gl_period_statuses

135: l_stmt_num := 40;
136: BEGIN
137: SELECT period_name
138: INTO x_gl_information.period_name
139: FROM gl_period_statuses
140: WHERE application_id = G_PO_APPLICATION_ID
141: AND set_of_books_id = p_set_of_books_id
142: AND trunc(start_date) <= trunc(p_event_date)
143: AND trunc(end_date) >= trunc(p_event_date)