DBA Data[Home] [Help]

APPS.ASO_SOURCING_PVT dependencies on HZ_CUST_ACCOUNTS

Line 451: FROM hz_cust_accounts

447: BEGIN
448:
449: SELECT customer_class_code
450: INTO x_class_code
451: FROM hz_cust_accounts
452: WHERE cust_account_id = p_cust_account_id;
453:
454: RETURN x_class_code;
455: EXCEPTION

Line 501: FROM hz_cust_accounts

497: BEGIN
498:
499: SELECT sales_channel_code
500: INTO x_sales_channel_code
501: FROM hz_cust_accounts
502: WHERE cust_account_id = p_cust_account_id;
503:
504: RETURN x_sales_channel_code;
505: EXCEPTION

Line 521: FROM hz_cust_accounts accts ,hz_parties party

517: BEGIN
518:
519: SELECT gsa_indicator_flag
520: INTO x_gsa
521: FROM hz_cust_accounts accts ,hz_parties party
522: WHERE accts.party_id=party.party_id
523: AND cust_account_id = p_cust_account_id;
524:
525: RETURN x_gsa;