eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_LOAN_PUB dependencies on HZ_CUST_ACCOUNTS

Line 556: FROM hz_cust_accounts_all hzca

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;

Line 579: FROM hz_cust_accounts_all account,

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

Line 1047: hz_cust_accounts account,

1043: ,v_remaining_balance(j)
1044: ,v_installment_number(j)
1045: FROM
1046: ar_payment_schedules_all pmt_sch,
1047: hz_cust_accounts account,
1048: RA_CUST_TRX_TYPES trx_type,
1049: ar_lookups trx_type_lkup,
1050: ar_lookups trx_class_lkup
1051: WHERE