DBA Data[Home] [Help]

APPS.IGC_CBC_PO_GRP dependencies on FND_APPLICATION

Line 488: fnd_application app

484: ,p_appl_name IN VARCHAR2)
485: IS
486: SELECT gps.closing_status
487: FROM gl_period_statuses gps,
488: fnd_application app
489: WHERE gps.application_id = app.application_id
490: AND app.application_short_name = p_appl_name
491: AND gps.set_of_books_id = p_sob_id
492: AND p_date BETWEEN gps.start_date AND gps.end_date

Line 1044: fnd_application b

1040: -- Cursor to get the start date of the next open period
1041: Cursor c_next_period_date(p_sob_id NUMBER) IS
1042: SELECT start_date
1043: FROM gl_period_statuses a,
1044: fnd_application b
1045: WHERE a.application_id = b.application_id
1046: AND b.application_short_name = 'PO'
1047: AND a.set_of_books_id = p_sob_id
1048: AND a.closing_status = 'O'