APPS.AS_SALES_LEAD_REFERRAL dependencies on HZ_PARTIES

Line 384: FROM as_sales_leads asl, hz_parties hp

380:
381: -- Get Customer Information
382: CURSOR lc_customer (pc_lead_id number) IS
383: SELECT hp.party_name, hp.city, hp.state, hp.country
384: FROM as_sales_leads asl, hz_parties hp
385: WHERE asl.sales_lead_id = pc_lead_id
386: AND hp.party_id = asl.customer_id;
387:
388:

Line 391: from AS_SALES_LEADS LEAD, HZ_PARTIES PARTNER, HZ_RELATIONSHIPS REL,HZ_ORGANIZATION_PROFILES ORG

387:
388:
389: CURSOR lc_ptnr_org_name(pc_party_id NUMBER) IS
390: SELECT ORG.PARTY_ID, partner.party_name
391: from AS_SALES_LEADS LEAD, HZ_PARTIES PARTNER, HZ_RELATIONSHIPS REL,HZ_ORGANIZATION_PROFILES ORG
392: where LEAD.REFERRED_BY=REL.PARTY_ID and REL.SUBJECT_ID=PARTNER.PARTY_ID
393: and REL.OBJECT_ID=ORG.PARTY_ID
394: and ORG.internal_flag = 'Y'
395: and ORG.effective_end_date is null

Line 414: hz_parties PUSER, hz_parties PARTNER, hz_parties VENDOR,

410: cursor c_get_ptnr_full_name (c_user_id number) is
411: select ARLKP.meaning ||' '||puser.person_first_name||' ' || puser.person_last_name partner_contact_name
412: from jtf_rs_resource_extns JS,
413: hz_relationships PCONTACT, hz_relationships PORG,
414: hz_parties PUSER, hz_parties PARTNER, hz_parties VENDOR,
415: hz_organization_profiles HZOP, pv_partner_profiles PVPP,
416: hz_org_contacts HZOC, ar_lookups ARLKP
417: where JS.user_id = c_user_id
418: AND JS.source_id = pcontact.party_id

Line 419: AND PCONTACT.subject_table_name = 'HZ_PARTIES'

415: hz_organization_profiles HZOP, pv_partner_profiles PVPP,
416: hz_org_contacts HZOC, ar_lookups ARLKP
417: where JS.user_id = c_user_id
418: AND JS.source_id = pcontact.party_id
419: AND PCONTACT.subject_table_name = 'HZ_PARTIES'
420: AND PCONTACT.object_table_name = 'HZ_PARTIES'
421: AND PCONTACT.RELATIONSHIP_TYPE in ('EMPLOYMENT')
422: AND PCONTACT.directional_flag = 'F'
423: AND PCONTACT.STATUS = 'A'

Line 420: AND PCONTACT.object_table_name = 'HZ_PARTIES'

416: hz_org_contacts HZOC, ar_lookups ARLKP
417: where JS.user_id = c_user_id
418: AND JS.source_id = pcontact.party_id
419: AND PCONTACT.subject_table_name = 'HZ_PARTIES'
420: AND PCONTACT.object_table_name = 'HZ_PARTIES'
421: AND PCONTACT.RELATIONSHIP_TYPE in ('EMPLOYMENT')
422: AND PCONTACT.directional_flag = 'F'
423: AND PCONTACT.STATUS = 'A'
424: AND PCONTACT.start_date <= SYSDATE

Line 431: AND PORG.subject_table_name = 'HZ_PARTIES'

427: AND PUSER.PARTY_TYPE = 'PERSON'
428: AND PUSER.status = 'A'
429: AND HZOC.party_relationship_id = PCONTACT.relationship_id
430: AND PORG.subject_id = PCONTACT.object_id
431: AND PORG.subject_table_name = 'HZ_PARTIES'
432: AND PORG.object_table_name = 'HZ_PARTIES'
433: AND PORG.RELATIONSHIP_TYPE in ('PARTNER', 'VAD')
434: AND PORG.STATUS = 'A'
435: AND PORG.start_date <= SYSDATE

Line 432: AND PORG.object_table_name = 'HZ_PARTIES'

428: AND PUSER.status = 'A'
429: AND HZOC.party_relationship_id = PCONTACT.relationship_id
430: AND PORG.subject_id = PCONTACT.object_id
431: AND PORG.subject_table_name = 'HZ_PARTIES'
432: AND PORG.object_table_name = 'HZ_PARTIES'
433: AND PORG.RELATIONSHIP_TYPE in ('PARTNER', 'VAD')
434: AND PORG.STATUS = 'A'
435: AND PORG.start_date <= SYSDATE
436: AND nvl(PORG.end_date, SYSDATE) >= SYSDATE