DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on GL_PERIOD_STATUSES_V

Line 1884: FROM gl_period_statuses_v

1880: p_default_date OUT NOCOPY DATE) IS
1881:
1882: CURSOR period_cur IS
1883: SELECT closing_status
1884: FROM gl_period_statuses_v
1885: WHERE application_id = 200
1886: and set_of_books_id = p_set_of_books_id
1887: and adjustment_period_flag = 'N'
1888: and p_gl_date between start_date and end_date;

Line 1892: FROM gl_period_statuses_v

1888: and p_gl_date between start_date and end_date;
1889:
1890: CURSOR default_cur IS
1891: SELECT max(end_date) default_date
1892: FROM gl_period_statuses_v
1893: WHERE application_id = 200
1894: and set_of_books_id = p_set_of_books_id
1895: and adjustment_period_flag = 'N'
1896: and start_date < p_gl_date