eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGC_CC_OPEN_INTERFACE_PKG dependencies on GL_PERIOD_STATUSES

Line 418: -- Performance Tuning, replaced gl_period_statuses_v

414:
415: BEGIN
416: -- Validate that the date is within an Open or Future Entry
417: -- GL / CC Period
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,

Line 419: -- gl_period_statuses_v gl,

415: BEGIN
416: -- Validate that the date is within an Open or Future Entry
417: -- GL / CC Period
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,

Line 424: gl_period_statuses 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
427: AND gl.set_of_books_id = sob.set_of_books_id
428: AND gl.application_id = app.application_id

Line 4956: FROM igc_cc_periods ccp, gl_sets_of_books sob, gl_period_statuses glp

4952: -- Validate the Cc_Det_Pf_Encmbrnc_Date
4953: IF P_Cc_Det_Pf_Encmbrnc_Date IS NOT NULL THEN
4954: BEGIN
4955: SELECT 1 INTO l_count
4956: FROM igc_cc_periods ccp, gl_sets_of_books sob, gl_period_statuses glp
4957: WHERE sob.set_of_books_id = P_Set_of_Books_Id
4958: AND sob.set_of_books_id = glp.set_of_books_id
4959: AND sob.accounted_period_type = glp.period_type
4960: AND sob.period_set_name = ccp.period_set_name