APPS.LNS_LOAN_PUB dependencies on HZ_CUST_ACCOUNTS

Line 1008: FROM hz_cust_accounts_all hzca

1004: ELSE
1005: BEGIN
1006: SELECT 'Y'
1007: INTO l_dummy
1008: FROM hz_cust_accounts_all hzca
1009: WHERE hzca.cust_account_id = P_Loan_Details_Rec.cust_account_id
1010: AND hzca.party_id = P_Loan_Details_Rec.primary_borrower_party_id
1011: AND hzca.status = 'A';
1012: l_cust_acct_valid := TRUE;

Line 1035: FROM hz_cust_accounts_all account,

1031: ELSE
1032: BEGIN
1033: SELECT 'Y'
1034: INTO l_dummy
1035: FROM hz_cust_accounts_all account,
1036: hz_cust_site_uses acc_site_use,
1037: hz_cust_acct_sites_all acct_site
1038: WHERE account.cust_account_id = acct_site.cust_account_id
1039: AND acc_site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 1953: FROM hz_cust_accounts_all hzca

1949: ELSE
1950: BEGIN
1951: SELECT 'Y'
1952: INTO l_dummy
1953: FROM hz_cust_accounts_all hzca
1954: WHERE hzca.cust_account_id = p_loan_part_tbl(l_count).cust_account_id
1955: AND hzca.party_id = p_loan_part_tbl(l_count).hz_party_id
1956: AND hzca.status = 'A';
1957: l_cust_acct_valid := TRUE;

Line 1980: FROM hz_cust_accounts_all account,

1976: ELSE
1977: BEGIN
1978: SELECT 'Y'
1979: INTO l_dummy
1980: FROM hz_cust_accounts_all account,
1981: hz_cust_site_uses acc_site_use,
1982: hz_cust_acct_sites_all acct_site
1983: WHERE account.cust_account_id = acct_site.cust_account_id
1984: AND acc_site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 2183: hz_cust_accounts account,

2179: ,p_loan_lines_tbl(l_count).remaining_balance
2180: ,p_loan_lines_tbl(l_count).installment_number
2181: FROM
2182: ar_payment_schedules_all pmt_sch,
2183: hz_cust_accounts account,
2184: RA_CUST_TRX_TYPES trx_type,
2185: ar_lookups trx_type_lkup,
2186: ar_lookups trx_class_lkup
2187: WHERE