723: INTO CONTACT_NAME,L_PERSON_TITLE
724: FROM
725: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
726: HZ_PARTIES PARTY,
727: HZ_RELATIONSHIPS REL,
728: HZ_ORG_CONTACTS ORG_CONT,
729: HZ_PARTIES REL_PARTY
730: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_BILL_TO_CONTACT_ID
731: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID
778: INTO CONTACT_NAME,L_PERSON_TITLE
779: FROM
780: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
781: HZ_PARTIES PARTY,
782: HZ_RELATIONSHIPS REL,
783: HZ_ORG_CONTACTS ORG_CONT,
784: HZ_PARTIES REL_PARTY
785: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = CP_SHIP_TO_CONTACT_ID
786: AND ACCT_ROLE.PARTY_ID = REL.PARTY_ID