DBA Data[Home] [Help]

APPS.AMW_FIN_COSO_VIEWS_PVT dependencies on AMW_FIN_CERT_SCOPE

Line 1750: (select DISTINCT NATURAL_ACCOUNT_ID from amw_fin_cert_scope where fin_certification_id = P_CERTIFICATION_ID and

1746: from
1747: amw_account_assertions
1748: where
1749: NATURAL_ACCOUNT_ID IN
1750: (select DISTINCT NATURAL_ACCOUNT_ID from amw_fin_cert_scope where fin_certification_id = P_CERTIFICATION_ID and
1751: financial_item_id = P_FINANCIAL_ITEM_ID );
1752:
1753:
1754:

Line 4522: (select DISTINCT NATURAL_ACCOUNT_ID from amw_fin_cert_scope where fin_certification_id = P_CERTIFICATION_ID and

4518: from
4519: amw_account_assertions
4520: where
4521: NATURAL_ACCOUNT_ID IN
4522: (select DISTINCT NATURAL_ACCOUNT_ID from amw_fin_cert_scope where fin_certification_id = P_CERTIFICATION_ID and
4523: financial_item_id = P_FINANCIAL_ITEM_ID );
4524:
4525:
4526:

Line 6878: amw_fin_cert_scope scope

6874: total_ctrl_attr_30
6875: from
6876: amw_certification_vl cert,
6877: amw_fin_cert_ctrl_sum ctrlsum,
6878: amw_fin_cert_scope scope
6879: where
6880: cert.certification_id = ctrlsum.fin_certification_id and
6881: ctrl_attribute_type = 'CTRL_ASSERTIONS'
6882: and

Line 6901: (select DISTINCT NATURAL_ACCOUNT_ID from amw_fin_cert_scope where fin_certification_id = P_CERTIFICATION_ID and

6897: from
6898: amw_account_assertions
6899: where
6900: NATURAL_ACCOUNT_ID IN
6901: (select DISTINCT NATURAL_ACCOUNT_ID from amw_fin_cert_scope where fin_certification_id = P_CERTIFICATION_ID and
6902: financial_item_id = P_FINANCIAL_ITEM_ID );
6903: ----------------------------------------------------------------------------------------------
6904: BEGIN
6905: