APPS.AST_ROUTING_PUB dependencies on AMS_CAMPAIGN_SCHEDULES_B

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'

Line 85: from ast_grp_campaigns agc, ams_campaign_schedules_b cs, jtf_rs_group_members gm, jtf_rs_groups_denorm gd

81: and arc.status = 'A'
82: and arc.enabled_flag = 'Y'
83: union
84: select distinct gm.resource_id
85: from ast_grp_campaigns agc, ams_campaign_schedules_b cs, jtf_rs_group_members gm, jtf_rs_groups_denorm gd
86: where agc.campaign_id = cs.schedule_id
87: and cs.source_code = p_source_code
88: and agc.enabled_flag = 'Y'
89: and agc.group_id = gd.parent_group_id