APPS.EDR_STANDARD dependencies on FND_APPLICATION

Line 157: FROM FND_APPLICATION

153: /* Select APPLICATION_ID of the Event. This is required by AME. Assumption made here
154: is OWNER_TAG will always be set to application Short Name*/
155:
156: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
157: FROM FND_APPLICATION
158: WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS
159: WHERE NAME=evt.getEventName( ));
160:
161: /* AME Enhancement Code. Determine if singature is need or not and also get approvers */

Line 208: FND_APPLICATION_ID=l_application_id and

204:
205: select application_name into l_application_name
206: from ame_Calling_Apps
207: where
208: FND_APPLICATION_ID=l_application_id and
209: TRANSACTION_TYPE_ID=NVL(l_ame_transaction_type,evt.getEventName( ))
210: --Bug 4652277: Start
211: --and end_Date is null;
212: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);

Line 399: FROM FND_APPLICATION

395: /* Select APPLICATION_ID of the Event. This is required by AME. Assumption made here
396: is OWNER_TAG will always be set to application Short Name*/
397:
398: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
399: FROM FND_APPLICATION
400: WHERE APPLICATION_SHORT_NAME in (SELECT OWNER_TAG from WF_EVENTS
401: WHERE NAME=evt.getEventName( ));
402:
403: /* AME Enhancement Code. Determine if singature is need or not and also get approvers */

Line 450: FND_APPLICATION_ID=l_application_id and

446: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','AME API Called. Total Approver '||approverlist.count );
447: select application_name into l_application_name
448: from ame_Calling_Apps
449: where
450: FND_APPLICATION_ID=l_application_id and
451: TRANSACTION_TYPE_ID=NVL(l_ame_transaction_type,evt.getEventName( ))
452: --Bug 4652277: Start
453: --and end_Date is null;
454: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);