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 200: l_org_id hr_operating_units.organization_id%TYPE;

196: TYPE ref_cur IS REF CURSOR;
197: l_xml_stmt ref_cur;
198: l_rows_processed NUMBER;
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;

Line 201: l_org_name hr_operating_units.NAME%TYPE;

197: l_xml_stmt ref_cur;
198: l_rows_processed NUMBER;
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;

Line 566: l_org_id hr_operating_units.organization_id%TYPE;

562: TYPE ref_cur IS REF CURSOR;
563: l_xml_stmt ref_cur;
564: l_rows_processed NUMBER;
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;

Line 567: l_org_name hr_operating_units.NAME%TYPE;

563: l_xml_stmt ref_cur;
564: l_rows_processed NUMBER;
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;

Line 791: 'hr_operating_units ou, ' ||

787: 'hz_party_sites site, ' ||
788: 'hz_cust_acct_sites_all acct_site, ' ||
789: 'lns_loan_products_vl product, ' ||
790: 'xle_entity_profiles le, ' ||
791: 'hr_operating_units ou, ' ||
792: 'lns_loan_types_vl lot ' ||
793: 'where ' ||
794: 'lh.primary_borrower_id = hp.party_id and ' ||
795: 'lh.loan_id = pay.loan_id and ' ||

Line 1014: l_org_id hr_operating_units.organization_id%TYPE;

1010: TYPE ref_cur IS REF CURSOR;
1011: l_xml_stmt ref_cur;
1012: l_rows_processed NUMBER;
1013: l_new_line VARCHAR2(1);
1014: l_org_id hr_operating_units.organization_id%TYPE;
1015: l_org_name hr_operating_units.NAME%TYPE;
1016: l_sob_currency_code gl_sets_of_books.CURRENCY_CODE%TYPE;
1017: l_amort_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
1018: l_return_status VARCHAR2(10);

Line 1015: l_org_name hr_operating_units.NAME%TYPE;

1011: l_xml_stmt ref_cur;
1012: l_rows_processed NUMBER;
1013: l_new_line VARCHAR2(1);
1014: l_org_id hr_operating_units.organization_id%TYPE;
1015: l_org_name hr_operating_units.NAME%TYPE;
1016: l_sob_currency_code gl_sets_of_books.CURRENCY_CODE%TYPE;
1017: l_amort_tbl LNS_FINANCIALS.AMORTIZATION_TBL;
1018: l_return_status VARCHAR2(10);
1019: l_msg_count NUMBER;

Line 1673: FROM hr_operating_units hou,

1669: -- Start Getting Parameter Display Values
1670: SELECT hou.name, gsb.currency_code
1671: INTO l_org_name,
1672: l_sob_currency_code
1673: FROM hr_operating_units hou,
1674: gl_sets_of_books gsb
1675: WHERE hou.organization_id = l_org_id
1676: AND gsb.set_of_books_id = hou.set_of_books_id;
1677: