APPS.LNS_REP_UTILS dependencies on HZ_CUST_ACCOUNTS

Line 203: l_account_number hz_cust_accounts.account_number%TYPE;

199: l_new_line VARCHAR2(1);
200: l_org_id hr_operating_units.organization_id%TYPE;
201: l_org_name hr_operating_units.NAME%TYPE;
202: l_borrower_name hz_parties.party_name%TYPE;
203: l_account_number hz_cust_accounts.account_number%TYPE;
204: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
205: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
206: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
207: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;

Line 204: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;

200: l_org_id hr_operating_units.organization_id%TYPE;
201: l_org_name hr_operating_units.NAME%TYPE;
202: l_borrower_name hz_parties.party_name%TYPE;
203: l_account_number hz_cust_accounts.account_number%TYPE;
204: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
205: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
206: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
207: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
208: l_loan_type_id lns_loan_types.loan_type_id%TYPE;

Line 280: 'hz_cust_accounts_all account, ' ||

276: 'hz_parties hp, ' ||
277: 'lns_terms t, ' ||
278: 'lns_lookups llk, ' ||
279: 'LNS_PAY_SUM_V pay, ' ||
280: 'hz_cust_accounts_all account, ' ||
281: 'lns_lookups llkrt, ' ||
282: 'lns_lookups llktt, ' ||
283: 'lns_lookups llks ' ||
284: 'where ' ||

Line 392: FROM hz_cust_accounts

388: IF cust_account_id is NOT NULL
389: THEN
390: SELECT account_number
391: into l_account_number
392: FROM hz_cust_accounts
393: WHERE cust_account_id = l_cust_account_id;
394: END IF;
395: IF loan_status1 is NOT NULL
396: THEN

Line 569: l_account_number hz_cust_accounts.account_number%TYPE;

565: l_new_line VARCHAR2(1);
566: l_org_id hr_operating_units.organization_id%TYPE;
567: l_org_name hr_operating_units.NAME%TYPE;
568: l_borrower_name hz_parties.party_name%TYPE;
569: l_account_number hz_cust_accounts.account_number%TYPE;
570: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
571: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
572: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
573: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;

Line 570: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;

566: l_org_id hr_operating_units.organization_id%TYPE;
567: l_org_name hr_operating_units.NAME%TYPE;
568: l_borrower_name hz_parties.party_name%TYPE;
569: l_account_number hz_cust_accounts.account_number%TYPE;
570: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
571: l_start_date_from lns_loan_headers_all.loan_start_date%TYPE;
572: l_start_date_to lns_loan_headers_all.loan_start_date%TYPE;
573: l_loan_type_desc lns_loan_types.loan_type_desc%TYPE;
574: l_loan_type_id lns_loan_types.loan_type_id%TYPE;

Line 784: 'hz_cust_accounts_all account, ' ||

780: ' from dual) dateparameters, ' ||
781: 'hz_parties hp, ' ||
782: 'lns_lookups llk, ' ||
783: 'LNS_PAY_SUM_V pay, ' ||
784: 'hz_cust_accounts_all account, ' ||
785: 'hz_locations loc, ' ||
786: 'fnd_territories_vl terr, ' ||
787: 'hz_party_sites site, ' ||
788: 'hz_cust_acct_sites_all acct_site, ' ||

Line 879: FROM hz_cust_accounts

875: IF cust_account_id is NOT NULL
876: THEN
877: SELECT account_number
878: into l_account_number
879: FROM hz_cust_accounts
880: WHERE cust_account_id = l_cust_account_id;
881: END IF;
882: IF legal_entity_id is NOT NULL
883: THEN