APPS.AS_SC_DENORM_TRG dependencies on HZ_PARTIES

Line 167: l_competitor_name hz_parties.party_name%TYPE;

163: l_weighted_amount NUMBER;
164: l_converted_won_amount NUMBER;
165: l_converted_weighted_amount NUMBER;
166: l_conversion_status_flag NUMBER;
167: l_competitor_name hz_parties.party_name%TYPE;
168: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;
169: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;
170: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;
171: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;

Line 185: From hz_parties

181: END IF;
182: Begin
183: Select party_name, party_type, category_code
184: Into l_customer_name, l_party_type, l_customer_category_code
185: From hz_parties
186: Where party_id = p_new_customer_id;
187: Exception
188: When Others then
189: l_customer_name := NULL;

Line 209: from hz_parties

205:
206: begin
207: select party_name
208: into l_competitor_name
209: from hz_parties
210: where party_id = p_new_close_competitor_id;
211: exception
212: when others then
213: l_competitor_name := NULL;

Line 679: l_competitor_name hz_parties.party_name%TYPE;

675: l_source_promotion_id as_leads_all.source_promotion_id%TYPE;
676: l_close_competitor_id as_leads_all.close_competitor_id%TYPE;
677: l_owner_salesforce_id as_leads_all.owner_salesforce_id%TYPE;
678: l_owner_sales_group_id as_leads_all.owner_sales_group_id%TYPE;
679: l_competitor_name hz_parties.party_name%TYPE;
680: l_owner_person_name jtf_rs_resource_extns.source_name%TYPE;
681: l_owner_first_name jtf_rs_resource_extns.source_first_name%TYPE;
682: l_owner_last_name jtf_rs_resource_extns.source_last_name%TYPE;
683: l_owner_group_name jtf_rs_groups_tl.group_name%TYPE;

Line 724: l_partner_cust_name hz_parties.party_name%Type;

720: l_organization_id as_lead_lines.organization_id%Type;
721: l_item_description as_sales_credits_denorm.item_description%Type;
722: l_revenue_flag aso_i_sales_credit_types_v.quota_flag%Type;
723: l_parent_project as_leads_all.parent_project%Type;
724: l_partner_cust_name hz_parties.party_name%Type;
725: l_business_group_name hr_all_organization_units_tl.name%Type;
726: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
727:
728: Begin

Line 842: From hz_parties

838:
839: Begin
840: Select party_name
841: Into l_partner_cust_name
842: From hz_parties
843: Where party_id = p_new_partner_customer_id;
844: Exception When Others then
845: l_partner_cust_name := Null;
846: End;

Line 873: From hz_parties cust, as_leads_all lead

869:
870: Begin
871: Select party_name, party_type, category_code
872: Into l_customer_name, l_party_type, l_customer_category_code
873: From hz_parties cust, as_leads_all lead
874: Where lead.customer_id = cust.party_id
875: And lead.lead_id = p_new_lead_id;
876: Exception When Others then
877: l_customer_name := Null;

Line 896: from hz_parties

892:
893: begin
894: select party_name
895: into l_competitor_name
896: from hz_parties
897: where party_id = l_close_competitor_id;
898: exception
899: when others then
900: l_competitor_name := NULL;