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.JA_CN_POST_UTILITY_PKG dependencies on JA_CN_JOURNAL_LINES

Line 1803: FROM /*JA_CN_JOURNAL_LINES jjl

1799:
1800: CURSOR c_periods(pc_year IN NUMBER
1801: ,pc_num IN NUMBER) IS
1802: SELECT DISTINCT gp.period_name,gp.period_year,gp.period_num
1803: FROM /*JA_CN_JOURNAL_LINES jjl
1804: , */gl_periods gp
1805: , gl_ledgers led
1806: WHERE /*jjl.ledger_id = p_ledger_id
1807: AND jjl.legal_entity_id = p_legal_entity_ID

Line 1841: FROM JA_CN_JOURNAL_LINES jjl

1837: , jjl.project_source
1838: , jjl.ACCOUNT_SEGMENT
1839: , jjl.period_name
1840: , substr(COMPILED_VALUE_ATTRIBUTES,5,1) account_type
1841: FROM JA_CN_JOURNAL_LINES jjl
1842: , FND_FLEX_VALUES ffv
1843: WHERE jjl.ledger_id = p_ledger_id
1844: AND jjl.legal_entity_id = p_legal_entity_ID
1845: AND jjl.status = 'U'

Line 2047: UPDATE ja_cn_journal_lines jl

2043:
2044: END LOOP;
2045:
2046: --update the journal status
2047: UPDATE ja_cn_journal_lines jl
2048: SET jl.status='P'
2049: WHERE jl.ledger_id = p_ledger_id
2050: AND jl.LEGAL_ENTITY_ID = p_legal_entity_ID
2051: AND jl.PERIOD_NAME = rec_period.period_name