DBA Data[Home] [Help]

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on WF_ITEMS

Line 113: FROM Wf_Items t, Wf_Item_Attribute_Values d

109: AND Jeh.Je_Header_Id = l_Je_Header_Id;
110:
111: CURSOR c_Batch_Approver IS
112: SELECT d.Text_Value
113: FROM Wf_Items t, Wf_Item_Attribute_Values d
114: WHERE d.Item_Key = t.Item_Key
115: AND d.NAME = 'APPROVER_NAME'
116: AND t.User_Key = l_Batch_Name
117: AND d.Item_Type = 'GLBATCH'

Line 120: FROM Wf_Items It,

116: AND t.User_Key = l_Batch_Name
117: AND d.Item_Type = 'GLBATCH'
118: AND t.Begin_Date IN
119: (SELECT MAX(It.Begin_Date)
120: FROM Wf_Items It,
121: Wf_Item_Attribute_Values T1,
122: Wf_Item_Attribute_Values t
123: WHERE It.User_Key = l_Batch_Name
124: AND It.Item_Key = t.Item_Key