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.PA_GL_TIEBACK_PKG dependencies on GL_JE_CATEGORIES

Line 33: from gl_je_Categories where je_category_name='Labor Cost');

29: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi
30: WHERE Status = 'NEW'
31: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)
32: AND user_je_category_name in ( select user_je_category_name
33: from gl_je_Categories where je_category_name='Labor Cost');
34:
35: Cursor Corruption_Usage is
36: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi
37: WHERE Status = 'NEW'

Line 40: from gl_je_Categories where je_category_name

36: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi
37: WHERE Status = 'NEW'
38: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)
39: AND user_je_category_name in ( select user_je_category_name
40: from gl_je_Categories where je_category_name
41: in ('Budget','Usage Cost'));
42:
43:
44: Cursor Corruption_Burden is

Line 49: from gl_je_Categories where je_category_name='Total Burdened Cost');

45: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi
46: WHERE Status = 'NEW'
47: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)
48: AND user_je_category_name in ( select user_je_category_name
49: from gl_je_Categories where je_category_name='Total Burdened Cost');
50:
51:
52: Cursor Corruption_Revenue is
53: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi

Line 57: from gl_je_Categories where je_category_name='Revenue');

53: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi
54: WHERE Status = 'NEW'
55: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)
56: AND user_je_category_name in ( select user_je_category_name
57: from gl_je_Categories where je_category_name='Revenue');
58:
59:
60:
61: Cursor Corruption_CrossCharge is

Line 66: from gl_je_Categories where je_category_name

62: SELECT gi.RowId Row_Id from Pa_Gl_Interface gi
63: WHERE Status = 'NEW'
64: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)
65: AND user_je_category_name in ( select user_je_category_name
66: from gl_je_Categories where je_category_name
67: in (Select gjc.je_category_name
68: FROM gl_je_categories gjc,
69: pa_lookups pl
70: WHERE pl.meaning = gjc.JE_CATEGORY_NAME

Line 68: FROM gl_je_categories gjc,

64: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)
65: AND user_je_category_name in ( select user_je_category_name
66: from gl_je_Categories where je_category_name
67: in (Select gjc.je_category_name
68: FROM gl_je_categories gjc,
69: pa_lookups pl
70: WHERE pl.meaning = gjc.JE_CATEGORY_NAME
71: and pl.lookup_type = 'CC_CCD_LINE_TYPE_JE_CATEGORY'));
72: