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_COA_EXP_PKG dependencies on PA_PROJECTS_ALL

Line 1141: -- PA_PROJECTS_ALL or FND_FLEX_VALUES_TL.

1137: WHERE set_of_books_id = l_sob_id
1138: AND global_attribute_category = 'JA.CN.GLXSTBKS.BOOKS';*/
1139:
1140: --Cursor to get project_number from table JA_CN_ACCOUNT_BALANCES, and name from table
1141: -- PA_PROJECTS_ALL or FND_FLEX_VALUES_TL.
1142: --If two projects from PA and COA are with a same number and same name then
1143: -- only show them one time.
1144: CURSOR c_pj IS
1145: SELECT *

Line 1152: ,PA_PROJECTS_ALL PPA

1148: SELECT DISTINCT
1149: BAL.project_number pj_number
1150: ,nvl(PPA.name, '') pj_name --name for project from PA
1151: FROM JA_CN_ACCOUNT_BALANCES BAL
1152: ,PA_PROJECTS_ALL PPA
1153: WHERE BAL.Ledger_Id= l_ledger_id --using variable l_sob_id
1154: AND BAL.account_segment IS NOT NULL
1155: AND nvl(BAL.project_source, 'N') = 'PA'
1156: and BAL.project_number IS NOT NULL