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_REP_UTILS dependencies on HR_OPERATING_UNITS

Line 226: l_org_id hr_operating_units.organization_id%TYPE;

222: TYPE ref_cur IS REF CURSOR;
223: l_xml_stmt ref_cur;
224: l_rows_processed NUMBER;
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;

Line 227: l_org_name hr_operating_units.NAME%TYPE;

223: l_xml_stmt ref_cur;
224: l_rows_processed NUMBER;
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;

Line 629: l_org_id hr_operating_units.organization_id%TYPE;

625: TYPE ref_cur IS REF CURSOR;
626: l_xml_stmt ref_cur;
627: l_rows_processed NUMBER;
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;

Line 630: l_org_name hr_operating_units.NAME%TYPE;

626: l_xml_stmt ref_cur;
627: l_rows_processed NUMBER;
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;

Line 854: 'hr_operating_units ou, ' ||

850: 'hz_party_sites site, ' ||
851: 'hz_cust_acct_sites_all acct_site, ' ||
852: 'lns_loan_products_vl product, ' ||
853: 'xle_entity_profiles le, ' ||
854: 'hr_operating_units ou, ' ||
855: 'lns_loan_types_vl lot ' ||
856: 'where ' ||
857: 'lh.primary_borrower_id = hp.party_id and ' ||
858: 'lh.loan_id = pay.loan_id and ' ||

Line 1080: l_org_name hr_operating_units.NAME%TYPE;

1076: TYPE ref_cur IS REF CURSOR;
1077: l_xml_stmt ref_cur;
1078: l_rows_processed NUMBER;
1079: l_new_line VARCHAR2(1);
1080: l_org_name hr_operating_units.NAME%TYPE;
1081: l_sob_currency_code gl_sets_of_books.CURRENCY_CODE%TYPE;
1082: l_amort_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
1083: l_return_status VARCHAR2(10);
1084: l_msg_count NUMBER;

Line 1839: FROM hr_operating_units hou,

1835:
1836: -- Start Getting Parameter Display Values
1837: SELECT hou.name, gsb.currency_code
1838: INTO l_org_name, l_sob_currency_code
1839: FROM hr_operating_units hou,
1840: gl_sets_of_books gsb,
1841: lns_loan_headers_all loan
1842: WHERE hou.organization_id = loan.org_id
1843: AND gsb.set_of_books_id = hou.set_of_books_id