APPS.OKL_RECEIPTS_PVT dependencies on GL_PERIOD_STATUSES

Line 61: FROM gl_period_statuses

57:
58: --get gl date from open accounting period
59: CURSOR c_get_gl_date(cp_date IN DATE) IS SELECT * from (
60: SELECT end_date gl_date, 1 Counter
61: FROM gl_period_statuses
62: WHERE application_id = 222
63: AND ledger_id = okl_accounting_util.get_set_of_books_id
64: AND closing_status IN ('F','O')
65: AND trunc(cp_date) between start_date and end_date

Line 69: FROM gl_period_statuses

65: AND trunc(cp_date) between start_date and end_date
66: AND adjustment_period_flag = 'N'
67: UNION
68: SELECT MAX(end_date) gl_date, 2 Counter
69: FROM gl_period_statuses
70: WHERE application_id = 222
71: AND ledger_id = okl_accounting_util.get_set_of_books_id
72: AND closing_status IN ('F','O')
73: AND end_date <= trunc(cp_date)

Line 77: FROM gl_period_statuses

73: AND end_date <= trunc(cp_date)
74: AND adjustment_period_flag = 'N'
75: UNION
76: SELECT MIN(start_date) gl_date, 3 Counter
77: FROM gl_period_statuses
78: WHERE application_id = 222
79: AND ledger_id = okl_accounting_util.get_set_of_books_id
80: AND closing_status IN ('F','O')
81: AND start_date >= trunc(cp_date)