APPS.PA_GL_TIEBACK_PKG dependencies on GL_INTERFACE_CONTROL

Line 31: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)

27:
28: Cursor Corruption_Labor is
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

Line 38: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)

34:
35: Cursor Corruption_Usage is
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:

Line 47: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)

43:
44: Cursor Corruption_Burden is
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:

Line 55: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)

51:
52: Cursor Corruption_Revenue is
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:

Line 64: AND not exists (Select 0 from gl_Interface_control gc where gc.group_id = gi.group_id)

60:
61: Cursor Corruption_CrossCharge is
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,

Line 79: exists in gl_interface control table for relevant group id */

75: Begin
76:
77: /* Identifying whether any relevant Interface process is running If not the corrupted records
78: will be marked as rejected. The cprrupted records means where Status is NEW and No record
79: exists in gl_interface control table for relevant group id */
80:
81: If P_Module = 'LABOR' Then
82: L_Interface_Process := 'PAGGLT';
83: Elsif P_Module = 'USAGE' Then