DBA Data[Home] [Help]

APPS.AP_WEB_RECEIPTS_WF dependencies on AP_AUD_RULE_ASSIGNMENTS_ALL

Line 81: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

77: ------------------------------------------------------------
78: select 'Y'
79: into l_is_notif_rule_setup
80: from AP_AUD_RULE_SETS rs,
81: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
82: where rsa.org_id = p_org_id
83: and rsa.rule_set_id = rs.rule_set_id
84: and rs.rule_set_type = C_NOTIFY_RULE
85: and TRUNC(p_report_submitted_date)