DBA Data[Home] [Help]

APPS.AP_WEB_AUDIT_UTILS dependencies on GL_PERIOD_STATUSES_V

Line 1926: FROM gl_period_statuses_v

1922: p_default_date OUT NOCOPY DATE) IS
1923:
1924: CURSOR period_cur IS
1925: SELECT closing_status
1926: FROM gl_period_statuses_v
1927: WHERE application_id = 200
1928: and set_of_books_id = p_set_of_books_id
1929: and adjustment_period_flag = 'N'
1930: and p_gl_date between start_date and end_date;

Line 1934: FROM gl_period_statuses_v

1930: and p_gl_date between start_date and end_date;
1931:
1932: CURSOR default_cur IS
1933: SELECT max(end_date) default_date
1934: FROM gl_period_statuses_v
1935: WHERE application_id = 200
1936: and set_of_books_id = p_set_of_books_id
1937: and adjustment_period_flag = 'N'
1938: and start_date < p_gl_date