DBA Data[Home] [Help]

APPS.OKE_DTS_WORKFLOW dependencies on OKE_NOTIFICATIONS

Line 351: FROM OKE_NOTIFICATIONS

347: ,BEFORE_AFTER
348: ,DURATION_DAYS
349: ,RECIPIENT
350: ,ROLE_ID
351: FROM OKE_NOTIFICATIONS
352: WHERE SOURCE_CODE = P_SOURCE_CODE
353: AND USAGE_CODE = P_USAGE_CODE
354: AND TARGET_DATE = P_TARGET_DATE
355: AND BEFORE_AFTER = 'BEFORE'

Line 589: FROM OKE_NOTIFICATIONS

585: ,BEFORE_AFTER
586: ,DURATION_DAYS
587: ,RECIPIENT
588: ,ROLE_ID
589: FROM OKE_NOTIFICATIONS
590: WHERE SOURCE_CODE = P_SOURCE_CODE
591: AND USAGE_CODE = P_USAGE_CODE
592: AND TARGET_DATE = P_TARGET_DATE
593: AND BEFORE_AFTER = 'AFTER'

Line 2416: FROM OKE_NOTIFICATIONS

2412: ,BEFORE_AFTER
2413: ,DURATION_DAYS
2414: ,RECIPIENT
2415: ,ROLE_ID
2416: FROM OKE_NOTIFICATIONS
2417: WHERE ID=P_DUE_NTF_ID
2418: ;
2419: REC_DUE_NTF CSR_DUE_NTF%ROWTYPE;
2420: