DBA Data[Home] [Help]

APPS.EDR_PSIG_RULE dependencies on FND_APPLICATION

Line 1938: FROM FND_APPLICATION A, WF_EVENTS B

1934: /* Select APPLICATION_ID of the Event. This is required by AME. Assumption made here
1935: is OWNER_TAG will always be set to application Short Name */
1936:
1937: SELECT application_id,APPLICATION_SHORT_NAME into l_application_id,l_application_code
1938: FROM FND_APPLICATION A, WF_EVENTS B
1939: WHERE A.APPLICATION_SHORT_NAME = B.OWNER_TAG
1940: AND B.NAME=P_EVENT.getEventName( );
1941:
1942: wf_log_pkg.string(1, 'EDR_PSIG_RULE.psig_rule','Application_id :'||l_application_id );

Line 2127: where FND_APPLICATION_ID=l_application_id and

2123:
2124: -- get the Application Name
2125: select ltrim(rtrim(application_name)) into l_application_name
2126: from ame_Calling_Apps
2127: where FND_APPLICATION_ID=l_application_id and
2128: TRANSACTION_TYPE_ID=NVL(l_ame_transaction_type,P_EVENT.getEventName( ))
2129: --Bug 4652277: Start
2130: --and end_Date is null;
2131: and sysdate between START_DATE AND NVL(END_DATE, SYSDATE);