APPS.ARP_TRX_DEFAULTS_3 dependencies on HZ_CUST_ACCOUNTS

Line 788: hz_cust_accounts.cust_account_id%type,

784: ra_customer_trx.trx_date%type,
785: p_currency_code IN
786: fnd_currencies.currency_code%type,
787: p_paying_customer_id IN
788: hz_cust_accounts.cust_account_id%type,
789: p_paying_site_use_id IN
790: hz_cust_site_uses.site_use_id%type,
791: p_bill_to_customer_id IN
792: hz_cust_accounts.cust_account_id%type,

Line 792: hz_cust_accounts.cust_account_id%type,

788: hz_cust_accounts.cust_account_id%type,
789: p_paying_site_use_id IN
790: hz_cust_site_uses.site_use_id%type,
791: p_bill_to_customer_id IN
792: hz_cust_accounts.cust_account_id%type,
793: p_bill_to_site_use_id IN
794: hz_cust_site_uses.site_use_id%type,
795: p_payment_method_name OUT NOCOPY
796: ar_receipt_methods.name%type,

Line 996: hz_cust_accounts.cust_account_id%type,

992: ra_customer_trx.trx_date%type,
993: p_currency_code IN
994: fnd_currencies.currency_code%type,
995: p_paying_customer_id IN
996: hz_cust_accounts.cust_account_id%type,
997: p_paying_site_use_id IN
998: hz_cust_site_uses.site_use_id%type,
999: p_bill_to_customer_id IN
1000: hz_cust_accounts.cust_account_id%type,

Line 1000: hz_cust_accounts.cust_account_id%type,

996: hz_cust_accounts.cust_account_id%type,
997: p_paying_site_use_id IN
998: hz_cust_site_uses.site_use_id%type,
999: p_bill_to_customer_id IN
1000: hz_cust_accounts.cust_account_id%type,
1001: p_bill_to_site_use_id IN
1002: hz_cust_site_uses.site_use_id%type,
1003: p_payment_type_code IN
1004: ar_receipt_methods.payment_type_code%type,

Line 1243: hz_cust_accounts.cust_account_id%type,

1239: ra_customer_trx.trx_date%type,
1240: p_currency_code IN
1241: fnd_currencies.currency_code%type,
1242: p_paying_customer_id IN
1243: hz_cust_accounts.cust_account_id%type,
1244: p_paying_site_use_id IN
1245: hz_cust_site_uses.site_use_id%type,
1246: p_bill_to_customer_id IN
1247: hz_cust_accounts.cust_account_id%type,

Line 1247: hz_cust_accounts.cust_account_id%type,

1243: hz_cust_accounts.cust_account_id%type,
1244: p_paying_site_use_id IN
1245: hz_cust_site_uses.site_use_id%type,
1246: p_bill_to_customer_id IN
1247: hz_cust_accounts.cust_account_id%type,
1248: p_bill_to_site_use_id IN
1249: hz_cust_site_uses.site_use_id%type,
1250: p_payment_type_code IN
1251: ar_receipt_methods.payment_type_code%type,

Line 1511: p_customer_id IN hz_cust_accounts.cust_account_id%type,

1507: PROCEDURE get_term_default(
1508: p_term_id IN ra_terms.term_id%type,
1509: p_type_term_id IN ra_terms.term_id%type,
1510: p_type_term_name IN ra_terms.name%type,
1511: p_customer_id IN hz_cust_accounts.cust_account_id%type,
1512: p_site_use_id IN hz_cust_site_uses.site_use_id%type,
1513: p_trx_date IN ra_customer_trx.trx_date%type,
1514: p_class IN ra_cust_trx_types.type%type,
1515: p_cust_trx_type_id IN ra_cust_trx_types.cust_trx_type_id%type,

Line 1974: hz_cust_accounts.cust_account_id%type

1970: +===========================================================================*/
1971:
1972: FUNCTION get_party_id (
1973: p_cust_account_id IN
1974: hz_cust_accounts.cust_account_id%type
1975: ) RETURN NUMBER IS
1976: l_party_id number;
1977: BEGIN
1978: IF PG_DEBUG in ('Y', 'C') THEN

Line 1984: from hz_cust_accounts

1980: END IF;
1981:
1982: Select party_id
1983: into l_party_id
1984: from hz_cust_accounts
1985: where cust_account_id = p_cust_account_id ;
1986: RETURN l_party_id;
1987: EXCEPTION
1988: WHEN NO_DATA_FOUND