eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

Line 3889: FROM ap_system_parameters_all SP --5126689

3885: 'Y',y_date,
3886: 'N',n_date,
3887: TRUNC(P_Date)))
3888: INTO l_current_date
3889: FROM ap_system_parameters_all SP --5126689
3890: WHERE sp.org_id = p_org_id;
3891:
3892: -- Initialize the IN OUT NOCOPY variables
3893: P_GL_Date := '';

Line 3930: ap_system_parameters_all SP

3926: is
3927: cursor l_current_cursor is
3928: SELECT period_name
3929: FROM gl_period_statuses GLPS,
3930: ap_system_parameters_all SP
3931: WHERE application_id = 200
3932: AND sp.org_id = P_Org_Id
3933: AND GLPS.set_of_books_id = SP.set_of_books_id
3934: AND trunc(P_Date) BETWEEN start_date AND end_date

Line 3971: ap_system_parameters_all SP

3967: cursor l_open_cursor is
3968: SELECT MIN(start_date),
3969: period_name
3970: FROM gl_period_statuses GLPS,
3971: ap_system_parameters_all SP
3972: WHERE application_id = 200
3973: AND sp.org_id = P_Org_Id
3974: AND GLPS.set_of_books_id = SP.set_of_books_id
3975: AND end_date >= P_Date --Bug6809792