APPS.AST_ROUTING_PUB dependencies on AST_RS_CAMPAIGNS

Line 78: from ast_rs_campaigns arc, ams_campaign_schedules_b cs

74: p_resources OUT NOCOPY resource_access_tbl_type) is
75:
76: cursor get_resources_for_source_code (p_source_code VARCHAR2) is
77: select distinct arc.resource_id
78: from ast_rs_campaigns arc, ams_campaign_schedules_b cs
79: where arc.campaign_id = cs.schedule_id
80: and cs.source_code = p_source_code
81: and arc.status = 'A'
82: and arc.enabled_flag = 'Y'