APPS.AMW_IMPORT_STMNTS_ACCS_PKG dependencies on AMW_FIN_STMNT_ITEMS_TL

Line 1201: delete AMW_FIN_STMNT_ITEMS_TL tl where exists(select base.STATEMENT_GROUP_ID, base.FINANCIAL_STATEMENT_ID

1197: from amw_certification_b cert where cert.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID
1198: and cert.FINANCIAL_STATEMENT_ID = tl.FINANCIAL_STATEMENT_ID and cert.OBJECT_TYPE =
1199: 'FIN_STMT');
1200:
1201: delete AMW_FIN_STMNT_ITEMS_TL tl where exists(select base.STATEMENT_GROUP_ID, base.FINANCIAL_STATEMENT_ID
1202: from AMW_FIN_STMNT_B base where base.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID
1203: and base.FINANCIAL_STATEMENT_ID = tl.FINANCIAL_STATEMENT_ID and base.end_date is not null
1204: ) and not exists (select cert.STATEMENT_GROUP_ID, cert.FINANCIAL_STATEMENT_ID
1205: from amw_certification_b cert where cert.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID

Line 2330: AMW_FIN_STMNT_ITEMS_tl

2326: begin
2327:
2328: select FINANCIAL_ITEM_ID INTO var_ITEM_ID
2329: from
2330: AMW_FIN_STMNT_ITEMS_tl
2331: where
2332: STATEMENT_GROUP_ID = X_STATEMENT_GROUP_ID and
2333: FINANCIAL_STATEMENT_ID = X_FINANCIAL_STATEMENT_ID and
2334: FINANCIAL_ITEM_ID = X_FINANCIAL_ITEM_ID and

Line 2339: insert into AMW_FIN_STMNT_ITEMS_TL(

2335: LANGUAGE=X_LANGUAGE ;
2336: EXCEPTION
2337: WHEN NO_DATA_FOUND THEN
2338:
2339: insert into AMW_FIN_STMNT_ITEMS_TL(
2340: STATEMENT_GROUP_ID,
2341: FINANCIAL_STATEMENT_ID,
2342: FINANCIAL_ITEM_ID,
2343: NAME,