APPS.AML_MONITOR_WF dependencies on HZ_PARTY_SITES

Line 86: hz_party_sites hzp,

82: -- Get Lead Info
83: CURSOR c_get_lead_info (c_sales_lead_id number) IS
84: SELECT hzl.country, asl.lead_rank_id, asl.creation_date
85: FROM as_sales_leads asl,
86: hz_party_sites hzp,
87: hz_locations hzl
88: WHERE hzl.location_id = hzp.location_id
89: AND hzp.party_site_id = asl.address_id
90: AND asl.sales_lead_id = c_sales_lead_id;

Line 2814: hz_party_sites hzp,

2810: -- Get Lead Info
2811: CURSOR c_get_lead_info1 (c_sales_lead_id number) IS
2812: SELECT hzl.country, asl.lead_rank_id
2813: FROM as_sales_leads asl,
2814: hz_party_sites hzp,
2815: hz_locations hzl
2816: WHERE hzl.location_id = hzp.location_id
2817: AND hzp.party_site_id = asl.address_id
2818: AND asl.sales_lead_id = c_sales_lead_id;