APPS.OZF_SCHEDULE_DENORM_PVT dependencies on HZ_CUST_ACCOUNTS

Line 99: hz_parties b, hz_cust_accounts ca,

95: FROM ozf_activity_hl_denorm am,
96: ams_campaign_schedules_vl s,
97: ams_campaigns_vl ct,
98: ams_list_entries le,
99: hz_parties b, hz_cust_accounts ca,
100: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu, hz_relationships hr
101: WHERE
102: s.schedule_id = am.schedule_id
103: and ct.campaign_id = s.campaign_id

Line 146: hz_parties b, hz_cust_accounts ca,

142: FROM ozf_activity_hl_denorm am,
143: ams_campaign_schedules_vl s,
144: ams_campaigns_vl ct,
145: ams_list_entries le,
146: hz_parties b, hz_cust_accounts ca,
147: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu
148: WHERE
149: am.schedule_id = s.schedule_id
150: and ct.campaign_id = s.campaign_id

Line 477: hz_cust_accounts ca,

473: s.activity_id, s.marketing_medium_id, hr.subject_id party_id, cs.cust_account_id,
474: cs.cust_acct_site_id, cu.site_use_id,cu.site_use_code,nvl(l_item_type,'ALLPRODUCTS') prod_indicator
475: FROM ams_campaign_schedules_vl s,
476: ams_campaigns_vl ct,
477: hz_cust_accounts ca,
478: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu, hz_relationships hr
479: WHERE
480: s.schedule_id = l_schedule_id
481: and ct.campaign_id = s.campaign_id

Line 497: hz_cust_accounts ca,

493: s.activity_id, s.marketing_medium_id, ca.party_id,cs.cust_account_id,
494: cs.cust_acct_site_id, cu.site_use_id,cu.site_use_code,nvl(l_item_type,'ALLPRODUCTS') prod_indicator
495: FROM ams_campaign_schedules_vl s,
496: ams_campaigns_vl ct,
497: hz_cust_accounts ca,
498: hz_cust_acct_sites_all cs,hz_cust_site_uses_all cu
499: WHERE
500: s.schedule_id = l_schedule_id
501: and ct.campaign_id = s.campaign_id