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.AMW_IMPORT_STMNTS_ACCS_PKG dependencies on AMW_FIN_STMNT_TL

Line 1193: delete AMW_FIN_STMNT_TL tl where exists(select base.STATEMENT_GROUP_ID, base.FINANCIAL_STATEMENT_ID

1189: update AMW_FIN_STMNT_B set end_date = sysdate
1190: where STATEMENT_GROUP_ID <> P_STATEMENT_GROUP_ID and
1191: FINANCIAL_STATEMENT_ID in (select FINANCIAL_STATEMENT_ID from AMW_FIN_STMNT_SELECTION where run_id = P_RUNID);
1192:
1193: delete AMW_FIN_STMNT_TL tl where exists(select base.STATEMENT_GROUP_ID, base.FINANCIAL_STATEMENT_ID
1194: from AMW_FIN_STMNT_B base where base.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID
1195: and base.FINANCIAL_STATEMENT_ID = tl.FINANCIAL_STATEMENT_ID and base.end_date is not null
1196: ) and not exists (select cert.STATEMENT_GROUP_ID, cert.FINANCIAL_STATEMENT_ID
1197: from amw_certification_b cert where cert.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID

Line 2124: AMW_FIN_STMNT_tl where

2120: begin
2121: select
2122: FINANCIAL_STATEMENT_ID into var_STATEMENT_ID
2123: from
2124: AMW_FIN_STMNT_tl where
2125: STATEMENT_GROUP_ID = X_STATEMENT_GROUP_ID and
2126: FINANCIAL_STATEMENT_ID = X_FINANCIAL_STATEMENT_ID and
2127: LANGUAGE =X_LANGUAGE ;
2128: EXCEPTION

Line 2131: insert into AMW_FIN_STMNT_tl(

2127: LANGUAGE =X_LANGUAGE ;
2128: EXCEPTION
2129: WHEN NO_DATA_FOUND THEN
2130:
2131: insert into AMW_FIN_STMNT_tl(
2132: STATEMENT_GROUP_ID,
2133: FINANCIAL_STATEMENT_ID,
2134: NAME,
2135: LANGUAGE,