APPS.LNS_REP_UTILS dependencies on HZ_CUST_ACCOUNTS

Line 229: l_account_number hz_cust_accounts.account_number%TYPE;

225: l_new_line VARCHAR2(1);
226: l_org_id hr_operating_units.organization_id%TYPE;
227: l_org_name hr_operating_units.NAME%TYPE;
228: l_borrower_name hz_parties.party_name%TYPE;
229: l_account_number hz_cust_accounts.account_number%TYPE;
230: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
231: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
232: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
233: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;

Line 230: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;

226: l_org_id hr_operating_units.organization_id%TYPE;
227: l_org_name hr_operating_units.NAME%TYPE;
228: l_borrower_name hz_parties.party_name%TYPE;
229: l_account_number hz_cust_accounts.account_number%TYPE;
230: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
231: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
232: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
233: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
234: l_loan_type_id lns_loan_types.loan_type_id%TYPE;

Line 306: 'hz_cust_accounts_all account, ' ||

302: 'hz_parties hp, ' ||
303: 'lns_terms t, ' ||
304: 'lns_lookups llk, ' ||
305: 'LNS_PAY_SUM_V pay, ' ||
306: 'hz_cust_accounts_all account, ' ||
307: 'lns_lookups llkrt, ' ||
308: 'lns_lookups llktt, ' ||
309: 'lns_lookups llks ' ||
310: 'where ' ||

Line 443: FROM hz_cust_accounts

439: IF cust_account_id is NOT NULL
440: THEN
441: SELECT account_number
442: into l_account_number
443: FROM hz_cust_accounts
444: WHERE cust_account_id = l_cust_account_id;
445: END IF;
446: IF loan_status1 is NOT NULL
447: THEN

Line 632: l_account_number hz_cust_accounts.account_number%TYPE;

628: l_new_line VARCHAR2(1);
629: l_org_id hr_operating_units.organization_id%TYPE;
630: l_org_name hr_operating_units.NAME%TYPE;
631: l_borrower_name hz_parties.party_name%TYPE;
632: l_account_number hz_cust_accounts.account_number%TYPE;
633: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
634: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
635: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
636: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;

Line 633: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;

629: l_org_id hr_operating_units.organization_id%TYPE;
630: l_org_name hr_operating_units.NAME%TYPE;
631: l_borrower_name hz_parties.party_name%TYPE;
632: l_account_number hz_cust_accounts.account_number%TYPE;
633: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
634: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
635: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
636: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
637: l_loan_type_id lns_loan_types.loan_type_id%TYPE;

Line 847: 'hz_cust_accounts_all account, ' ||

843: ' from dual) dateparameters, ' ||
844: 'hz_parties hp, ' ||
845: 'lns_lookups llk, ' ||
846: 'LNS_PAY_SUM_V pay, ' ||
847: 'hz_cust_accounts_all account, ' ||
848: 'hz_locations loc, ' ||
849: 'fnd_territories_vl terr, ' ||
850: 'hz_party_sites site, ' ||
851: 'hz_cust_acct_sites_all acct_site, ' ||

Line 942: FROM hz_cust_accounts

938: IF cust_account_id is NOT NULL
939: THEN
940: SELECT account_number
941: into l_account_number
942: FROM hz_cust_accounts
943: WHERE cust_account_id = l_cust_account_id;
944: END IF;
945: IF legal_entity_id is NOT NULL
946: THEN