APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on HZ_PARTIES

Line 473: HZ_PARTIES PARTY,

469: SUBSTRB(PARTY.PARTY_NAME
470: ,1
471: ,50) CUSTOMER_NAME
472: FROM
473: HZ_PARTIES PARTY,
474: HZ_CUST_ACCOUNTS CUST_ACCT,
475: OE_ORDER_HEADERS_ALL OH
476: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
477: AND OH.HEADER_ID = O_ID

Line 479: NAME HZ_PARTIES.PARTY_NAME%TYPE := ' ';

475: OE_ORDER_HEADERS_ALL OH
476: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
477: AND OH.HEADER_ID = O_ID
478: AND CUST_ACCT.CUST_ACCOUNT_ID = OH.SOLD_TO_ORG_ID;
479: NAME HZ_PARTIES.PARTY_NAME%TYPE := ' ';
480: BEGIN
481: IF CUSTOMER_FLAG = 'Y' THEN
482: OPEN CUSTOMER_NAME(SOURCE_HEADER_ID);
483: FETCH CUSTOMER_NAME

Line 501: HZ_PARTIES PARTY,

497: SUBSTRB(PARTY.PARTY_NAME
498: ,1
499: ,50) CUSTOMER_NAME
500: FROM
501: HZ_PARTIES PARTY,
502: HZ_CUST_ACCOUNTS CUST_ACCT,
503: OE_ORDER_HEADERS_ALL OH
504: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
505: AND OH.HEADER_ID = O_ID

Line 507: NAME HZ_PARTIES.PARTY_NAME%TYPE := ' ';

503: OE_ORDER_HEADERS_ALL OH
504: WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
505: AND OH.HEADER_ID = O_ID
506: AND CUST_ACCT.CUST_ACCOUNT_ID = OH.SOLD_TO_ORG_ID;
507: NAME HZ_PARTIES.PARTY_NAME%TYPE := ' ';
508: BEGIN
509: IF CUSTOMER_FLAG = 'Y' THEN
510: OPEN CUSTOMER_NAME(SOURCE_HEADER_ID);
511: FETCH CUSTOMER_NAME