DBA Data[Home] [Help]

APPS.PSP_PEE_BUS dependencies on GL_SETS_OF_BOOKS

Line 393: FROM gl_sets_of_books

389: l_set_of_books_id NUMBER;
390: --
391: CURSOR set_of_books_id_csr IS
392: SELECT set_of_books_id
393: FROM gl_sets_of_books
394: WHERE set_of_books_id = p_set_of_books_id;
395: --
396: BEGIN
397: --

Line 991: FROM gl_sets_of_books

987: AND p_distribution_date between DATE_FROM and nvl(DATE_TO,to_date('31/12/4712','DD/MM/RRRR'));
988:
989: CURSOR set_of_books_csr(p_set_of_books_id IN NUMBER) IS
990: SELECT set_of_books_id
991: FROM gl_sets_of_books
992: WHERE set_of_books_id = p_set_of_books_id;
993:
994: CURSOR person_csr(p_person_id IN NUMBER, p_business_group_id IN NUMBER, p_distribution_date IN DATE) IS
995: SELECT person_id