DBA Data[Home] [Help]

APPS.EDR_ISIGN_CHECKLIST_PVT dependencies on FND_APPLICATION

Line 117: FROM FND_APPLICATION

113: /* Select APPLICATION_ID of the Event. This is required by AME. Assumption made here
114: is OWNER_TAG will always be set to application Short Name*/
115:
116: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
117: FROM FND_APPLICATION
118: WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS
119: WHERE NAME=evt.getEventName( ));
120:
121: /* AME Enhancement Code. Determine if singature is need or not and also get approvers */

Line 156: where FND_APPLICATION_ID=l_application_id

152:
153: -- Bug 5167817 : end
154: select application_name into l_application_name
155: from ame_Calling_Apps
156: where FND_APPLICATION_ID=l_application_id
157: and TRANSACTION_TYPE_ID=NVL(l_ame_transaction_type,evt.getEventName( ))
158: --Bug 4652277: Start
159: --and end_Date is null;
160: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);