APPS.WSH_WSHRDPIK_XMLP_PKG dependencies on HZ_PARTIES

Line 474: HZ_PARTIES PARTY,

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

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

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

Line 502: HZ_PARTIES PARTY,

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

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

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