APPS.AMW_IMPORT_STMNTS_ACCS_PKG dependencies on AMW_FIN_STMNT_ITEMS_B

Line 1209: delete AMW_FIN_STMNT_ITEMS_B tl where exists(select base.STATEMENT_GROUP_ID, base.FINANCIAL_STATEMENT_ID

1205: from amw_certification_b cert where cert.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID
1206: and cert.FINANCIAL_STATEMENT_ID = tl.FINANCIAL_STATEMENT_ID and cert.OBJECT_TYPE =
1207: 'FIN_STMT');
1208:
1209: delete AMW_FIN_STMNT_ITEMS_B tl where exists(select base.STATEMENT_GROUP_ID, base.FINANCIAL_STATEMENT_ID
1210: from AMW_FIN_STMNT_B base where base.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID
1211: and base.FINANCIAL_STATEMENT_ID = tl.FINANCIAL_STATEMENT_ID and base.end_date is not null
1212: ) and not exists (select cert.STATEMENT_GROUP_ID, cert.FINANCIAL_STATEMENT_ID
1213: from amw_certification_b cert where cert.STATEMENT_GROUP_ID= tl.STATEMENT_GROUP_ID

Line 2220: AMW_FIN_STMNT_ITEMS_B

2216: begin
2217: select
2218: FINANCIAL_ITEM_ID INTO var_ITEM_ID
2219: from
2220: AMW_FIN_STMNT_ITEMS_B
2221: where
2222: STATEMENT_GROUP_ID = X_STATEMENT_GROUP_ID and
2223: FINANCIAL_STATEMENT_ID = X_FINANCIAL_STATEMENT_ID and
2224: FINANCIAL_ITEM_ID = X_FINANCIAL_ITEM_ID and

Line 2230: insert into AMW_FIN_STMNT_ITEMS_B(

2226:
2227: EXCEPTION
2228: WHEN NO_DATA_FOUND THEN
2229:
2230: insert into AMW_FIN_STMNT_ITEMS_B(
2231: STATEMENT_GROUP_ID,
2232: FINANCIAL_STATEMENT_ID,
2233: FINANCIAL_ITEM_ID,
2234: PARENT_FINANCIAL_ITEM_ID,

Line 2792: from amw_fin_stmnt_items_b items

2788: cursor item_cursor is
2789: select distinct items.financial_item_id item_id,
2790: items.statement_group_id group_id,
2791: items.financial_statement_id stmt_id
2792: from amw_fin_stmnt_items_b items
2793: where items.statement_group_id = x_group_id;
2794:
2795: cursor nested_cursor ( p_stmt_id number, p_group_id number, p_item_id number ) is
2796:

Line 2801: from amw_fin_stmnt_items_b items

2797: select p_item_id parent_id,
2798: items.financial_item_id child_id,
2799: items.statement_group_id group_id,
2800: items.financial_statement_id stmt_id
2801: from amw_fin_stmnt_items_b items
2802: start with items.statement_group_id = p_group_id
2803: and items.parent_financial_item_id = p_item_id
2804: and items.financial_statement_id = p_stmt_id
2805: connect by prior items.financial_item_id = items.parent_financial_item_id