APPS.EDR_STANDARD dependencies on AME_CALLING_APPS

Line 206: from ame_Calling_Apps

202: -- Bug 5167817 : end
203: wf_log_pkg.string(6, 'EDR_STANDARD.psig_rule','AME API Called. Total Approver '||approverlist.count );
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

Line 448: from ame_Calling_Apps

444:
445: -- Bug 5167817 : end
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

Line 648: ( select distinct application_name from ame_calling_apps where transaction_type_id = the_trans_id)

644: CURSOR C1( the_trans_id VARCHAR2 ) is
645: SELECT INPUT_NAME, INPUT_VALUE
646: from EDR_AMERULE_INPUT_VAR
647: where AME_TRANS_NAME in
648: ( select distinct application_name from ame_calling_apps where transaction_type_id = the_trans_id)
649: AND RULE_ID=ameruleid;
650:
651: CURSOR TID is
652: Select distinct transaction_type_id FROM ame_calling_apps

Line 652: Select distinct transaction_type_id FROM ame_calling_apps

648: ( select distinct application_name from ame_calling_apps where transaction_type_id = the_trans_id)
649: AND RULE_ID=ameruleid;
650:
651: CURSOR TID is
652: Select distinct transaction_type_id FROM ame_calling_apps
653: WHERE application_name = ameapplication
654: --Bug 4652277: Start
655: --AND end_date is null;
656: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);