DBA Data[Home] [Help]

APPS.AP_WEB_RECEIPTS_WF dependencies on AP_AUD_RULE_ASSIGNMENTS_ALL

Line 74: AP_AUD_RULE_ASSIGNMENTS_ALL rsa

70: ------------------------------------------------------------
71: select 'Y'
72: into l_is_notif_rule_setup
73: from AP_AUD_RULE_SETS rs,
74: AP_AUD_RULE_ASSIGNMENTS_ALL rsa
75: where rsa.org_id = p_org_id
76: and rsa.rule_set_id = rs.rule_set_id
77: and rs.rule_set_type = C_NOTIFY_RULE
78: and TRUNC(p_report_submitted_date)