DBA Data[Home] [Help]

APPS.PNRX_RENT_INCREASE_DETAIL dependencies on HZ_CUST_ACCOUNTS

Line 1060: FROM hz_cust_accounts hca, hz_parties hp

1056: BEGIN
1057: SELECT SUBSTR (hp.party_name, 1, 30),
1058: hca.account_number
1059: INTO l_customer_rec
1060: FROM hz_cust_accounts hca, hz_parties hp
1061: WHERE cust_account_id = p_customer_id
1062: AND hca.party_id = hp.party_id;
1063:
1064: RETURN (l_customer_rec);