552: ELSE
553: BEGIN
554: SELECT 'Y'
555: INTO l_dummy
556: FROM hz_cust_accounts_all hzca
557: WHERE hzca.cust_account_id = P_Loan_Details_Rec.cust_account_id
558: AND hzca.party_id = P_Loan_Details_Rec.primary_borrower_party_id
559: AND hzca.status = 'A';
560: l_cust_acct_valid := TRUE;
575: ELSE
576: BEGIN
577: SELECT 'Y'
578: INTO l_dummy
579: FROM hz_cust_accounts_all account,
580: hz_cust_site_uses acc_site_use,
581: hz_cust_acct_sites_all acct_site
582: WHERE account.cust_account_id = acct_site.cust_account_id
583: AND acc_site_use.cust_acct_site_id = acct_site.cust_acct_site_id