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.CN_PAYRUN_PVT dependencies on GL_SETS_OF_BOOKS

Line 392: FROM gl_sets_of_books glsob,

388:
389: CURSOR cn_repositories_cur IS
390: SELECT glsob.set_of_books_id set_of_books_id,
391: glsob.currency_code currency_code
392: FROM gl_sets_of_books glsob,
393: cn_repositories cnr,
394: cn_payruns cnp
395: WHERE cnr.set_of_books_id = glsob.set_of_books_id
396: AND cnr.org_id = cnp.org_id

Line 1525: FROM gl_sets_of_books glsob,

1521: l_pay_date DATE;
1522:
1523: CURSOR get_functional_currency IS
1524: SELECT currency_code
1525: FROM gl_sets_of_books glsob,
1526: cn_repositories cnr,
1527: cn_payruns cnp
1528: WHERE cnr.set_of_books_id = glsob.set_of_books_id
1529: AND cnr.org_id = cnp.org_id

Line 1531: l_functional_currency gl_sets_of_books.currency_code%TYPE;

1527: cn_payruns cnp
1528: WHERE cnr.set_of_books_id = glsob.set_of_books_id
1529: AND cnr.org_id = cnp.org_id
1530: AND cnp.payrun_id= p_payrun_id;
1531: l_functional_currency gl_sets_of_books.currency_code%TYPE;
1532:
1533: l_lookup_type VARCHAR2(30) := 'STANDARD';
1534: l_org_id number;
1535: l_supplier_id po_vendor_sites.vendor_id%TYPE;