DBA Data[Home] [Help]

APPS.AP_PAY_INVOICE_PKG dependencies on GL_PERIOD_STATUSES

Line 394: FROM gl_period_statuses G, ap_system_parameters P

390: BEGIN
391: debug_info := 'Get period_name';
392: SELECT G.period_name
393: INTO P_period_name
394: FROM gl_period_statuses G, ap_system_parameters P
395: WHERE G.application_id = 200
396: AND G.set_of_books_id = P.set_of_books_id
397: AND DECODE(P_accounting_date, '',
398: sysdate, P_accounting_date) between G.start_date and G.end_date

Line 407: FROM gl_period_statuses G, ap_system_parameters P

403: EXCEPTION WHEN NO_DATA_FOUND THEN
404: BEGIN
405: SELECT G.start_date, G.period_name
406: INTO l_gl_date, P_period_name
407: FROM gl_period_statuses G, ap_system_parameters P
408: WHERE G.application_id = 200
409: AND G.set_of_books_id = P.set_of_books_id
410: AND G.start_date = (SELECT min(G1.start_date)
411: FROM gl_period_statuses G1

Line 411: FROM gl_period_statuses G1

407: FROM gl_period_statuses G, ap_system_parameters P
408: WHERE G.application_id = 200
409: AND G.set_of_books_id = P.set_of_books_id
410: AND G.start_date = (SELECT min(G1.start_date)
411: FROM gl_period_statuses G1
412: WHERE G1.application_id = 200
413: AND G1.set_of_books_id = P.set_of_books_id
414: AND G1.start_date > DECODE(P_accounting_date, '',
415: sysdate, P_accounting_date)