DBA Data[Home] [Help]

APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on FND_APPLICATION

Line 422: FROM fnd_application app,

418: -- Performance Tuning, replaced gl_period_statuses_v
419: -- gl_period_statuses_v gl,
420: SELECT count(*)
421: INTO l_COUNT
422: FROM fnd_application app,
423: gl_sets_of_books sob,
424: gl_period_statuses gl,
425: igc_cc_periods cp
426: WHERE sob.set_of_books_id = p_set_of_books_id

Line 4706: l_gl_application_id fnd_application.application_id%TYPE;

4702: l_count NUMBER;
4703: l_func_amt NUMBER;
4704: l_det_pf_date DATE;
4705: l_user_id NUMBER;
4706: l_gl_application_id fnd_application.application_id%TYPE;
4707:
4708: BEGIN
4709:
4710: -- --------------------------------------------------------------------

Line 4715: FROM fnd_application

4711: -- Obtain the application ID that will be used throughout this process.
4712: -- --------------------------------------------------------------------
4713: SELECT application_id
4714: INTO l_gl_application_id
4715: FROM fnd_application
4716: WHERE application_short_name = 'SQLGL';
4717:
4718: -- Validate Interface Parent Acct Line Id. Should not be null and should be a valid
4719: -- valid one for CC type 'R'