APPS.AMW_FIN_COSO_VIEWS_PVT dependencies on AMW_ACCOUNT_ASSERTIONS

Line 1724: amw_account_assertions

1720: is
1721: select
1722: ASSERTION_CODE
1723: from
1724: amw_account_assertions
1725: where
1726: NATURAL_ACCOUNT_ID =P_ACCOUNT_ID ;
1727: */
1728:

Line 1735: amw_account_assertions

1731: select
1732: distinct
1733: ASSERTION_CODE
1734: from
1735: amw_account_assertions
1736: where
1737: ((NATURAL_ACCOUNT_ID =P_ACCOUNT_ID) or (NATURAL_ACCOUNT_ID in (select CHILD_NATURAL_ACCOUNT_ID from amw_fin_key_acct_flat
1738: where PARENT_NATURAL_ACCOUNT_ID =P_ACCOUNT_ID and ACCOUNT_GROUP_ID=P_ACCOUNT_GROUP_ID)));
1739:

Line 1747: amw_account_assertions

1743: is
1744: select DISTINCT
1745: ASSERTION_CODE
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 );

Line 4519: amw_account_assertions

4515: is
4516: select DISTINCT
4517: ASSERTION_CODE
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 );

Line 5014: amw_account_assertions

5010: is
5011: select
5012: ASSERTION_CODE
5013: from
5014: amw_account_assertions
5015: where
5016: NATURAL_ACCOUNT_ID =P_ACCOUNT_ID ;
5017: */
5018:

Line 5025: amw_account_assertions

5021: select
5022: distinct
5023: ASSERTION_CODE
5024: from
5025: amw_account_assertions
5026: where
5027: ((NATURAL_ACCOUNT_ID =P_ACCOUNT_ID) or (NATURAL_ACCOUNT_ID in (select CHILD_NATURAL_ACCOUNT_ID from amw_fin_key_acct_flat
5028: where PARENT_NATURAL_ACCOUNT_ID =P_ACCOUNT_ID and ACCOUNT_GROUP_ID=P_ACCOUNT_GROUP_ID)));
5029:

Line 6342: amw_account_assertions

6338: is
6339: select
6340: ASSERTION_CODE
6341: from
6342: amw_account_assertions
6343: where
6344: NATURAL_ACCOUNT_ID =P_ACCOUNT_ID ;
6345: */
6346:

Line 6356: amw_account_assertions

6352: select
6353: distinct
6354: ASSERTION_CODE
6355: from
6356: amw_account_assertions
6357: where
6358: ((NATURAL_ACCOUNT_ID =P_ACCOUNT_ID) or (NATURAL_ACCOUNT_ID in (select CHILD_NATURAL_ACCOUNT_ID from amw_fin_key_acct_flat
6359: where PARENT_NATURAL_ACCOUNT_ID =P_ACCOUNT_ID and ACCOUNT_GROUP_ID=M_ACCOUNT_GROUP_ID)));
6360:

Line 6898: amw_account_assertions

6894: is
6895: select DISTINCT
6896: ASSERTION_CODE
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 );

Line 7414: amw_account_assertions

7410: select
7411: distinct
7412: ASSERTION_CODE
7413: from
7414: amw_account_assertions
7415: where
7416: ((NATURAL_ACCOUNT_ID =M_PARENT_ACCOUNT_ID) or (NATURAL_ACCOUNT_ID in (select CHILD_NATURAL_ACCOUNT_ID from amw_fin_key_acct_flat
7417: where PARENT_NATURAL_ACCOUNT_ID =M_PARENT_ACCOUNT_ID and ACCOUNT_GROUP_ID=P_ACCOUNT_GROUP_ID)));
7418: