DBA Data[Home] [Help]

APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on WF_ITEMS

Line 94: FROM Wf_Items t, Wf_Item_Attribute_Values d

90: AND Jeh.Je_Header_Id = l_Je_Header_Id;
91:
92: CURSOR c_Batch_Approver IS
93: SELECT d.Text_Value
94: FROM Wf_Items t, Wf_Item_Attribute_Values d
95: WHERE d.Item_Key = t.Item_Key
96: AND d.NAME = 'APPROVER_NAME'
97: AND t.User_Key = l_Batch_Name
98: AND d.Item_Type = 'GLBATCH'

Line 101: FROM Wf_Items It,

97: AND t.User_Key = l_Batch_Name
98: AND d.Item_Type = 'GLBATCH'
99: AND t.Begin_Date IN
100: (SELECT MAX(It.Begin_Date)
101: FROM Wf_Items It,
102: Wf_Item_Attribute_Values T1,
103: Wf_Item_Attribute_Values t
104: WHERE It.User_Key = l_Batch_Name
105: AND It.Item_Key = t.Item_Key