APPS.AST_ROUTING_PUB dependencies on JTF_RS_GROUP_MEMBERS

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