APPS.ALR_DBTRIGGER dependencies on FND_ORACLE_USERID

Line 142: FND_ORACLE_USERID FOU

138:
139: select fou.oracle_username
140: into t_schema
141: from FND_PRODUCT_INSTALLATIONS FPI,
142: FND_ORACLE_USERID FOU
143: where fpi.application_id = 0
144: and fpi.oracle_id = fou.oracle_id;
145:
146: -- Could use FND_INSTALLATION.GET_APP_INFO as well,

Line 246: fnd_oracle_userid o

242: cursor C is
243: select DISTINCT ORACLE_USERNAME, DATA_GROUP_ID ORG_ID
244: from alr_alerts a,
245: alr_alert_installations i,
246: fnd_oracle_userid o
247: where a.alert_condition_type='E'
248: and 'Y'=decode(EVENT_MODE, 'I', a.insert_flag,
249: 'U', a.update_flag,
250: 'D', a.delete_flag)

Line 564: from FND_ORACLE_USERID O, ALR_ALERT_INSTALLATIONS I

560:
561: cursor c1 is
562: select DISTINCT
563: ORACLE_USERNAME, O.ORACLE_ID
564: from FND_ORACLE_USERID O, ALR_ALERT_INSTALLATIONS I
565: where O.ORACLE_ID = NVL(OID, O.ORACLE_ID)
566: and O.ORACLE_ID = I.ORACLE_ID
567: and I.APPLICATION_ID = APPL_ID
568: and I.ALERT_ID = ALR_ID

Line 963: from FND_ORACLE_USERID O, ALR_ALERT_INSTALLATIONS I

959:
960: cursor C is
961: select DISTINCT
962: ORACLE_USERNAME, O.ORACLE_ID, I.ENABLED_FLAG ENABLED_INST
963: from FND_ORACLE_USERID O, ALR_ALERT_INSTALLATIONS I
964: where O.ORACLE_ID = NVL(OID, O.ORACLE_ID)
965: and O.ORACLE_ID = I.ORACLE_ID
966: and I.APPLICATION_ID = NVL(APPL_ID, I.APPLICATION_ID)
967: and I.ALERT_ID = NVL(ALR_ID, I.ALERT_ID)