DBA Data[Home] [Help]

APPS.AP_UTILITIES_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 405: ap_system_parameters_all SP

401: is
402: cursor l_current_cursor is
403: SELECT period_name
404: FROM gl_period_statuses GLPS,
405: ap_system_parameters_all SP
406: WHERE application_id = 200
407: AND sp.org_id = P_Org_Id
408: AND GLPS.set_of_books_id = SP.set_of_books_id
409: AND trunc(P_Date) BETWEEN start_date AND end_date

Line 492: ap_system_parameters_all SP

488: is
489: cursor l_current_cursor is
490: SELECT period_name
491: FROM gl_period_statuses GLPS,
492: ap_system_parameters_all SP
493: WHERE application_id = 200
494: AND sp.org_id = p_org_id
495: AND GLPS.set_of_books_id = SP.set_of_books_id
496: /* Bug 5368685 */

Line 533: ap_system_parameters_all SP

529: cursor l_open_cursor is
530: SELECT MIN(start_date),
531: period_name
532: FROM gl_period_statuses GLPS,
533: ap_system_parameters_all SP
534: WHERE application_id = 200
535: AND sp.org_id = P_Org_Id
536: AND GLPS.set_of_books_id = SP.set_of_books_id
537: AND end_date >= P_Date --Bug6809792

Line 635: ap_system_parameters_all SP --8281653

631: cursor l_open_cursor is
632: SELECT MIN(start_date),
633: period_name
634: FROM gl_period_statuses GLPS,
635: ap_system_parameters_all SP --8281653
636: WHERE application_id = 200
637: AND SP.org_id = P_Org_Id
638: AND GLPS.set_of_books_id = SP.set_of_books_id
639: AND (start_date > P_Date OR