APPS.AMW_FIN_COSO_VIEWS_PVT dependencies on AMW_FIN_KEY_ACCT_FLAT

Line 1737: ((NATURAL_ACCOUNT_ID =P_ACCOUNT_ID) or (NATURAL_ACCOUNT_ID in (select CHILD_NATURAL_ACCOUNT_ID from amw_fin_key_acct_flat

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:
1740:
1741: -- ================================= Get Account Assertion COdes FOR A FINANCIAL ITEM ===============================

Line 5027: ((NATURAL_ACCOUNT_ID =P_ACCOUNT_ID) or (NATURAL_ACCOUNT_ID in (select CHILD_NATURAL_ACCOUNT_ID from amw_fin_key_acct_flat

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:
5030: ----------------------------------------------------
5031: g_user_id NUMBER := fnd_global.user_id;

Line 6358: ((NATURAL_ACCOUNT_ID =P_ACCOUNT_ID) or (NATURAL_ACCOUNT_ID in (select CHILD_NATURAL_ACCOUNT_ID from amw_fin_key_acct_flat

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:
6361: -----------------------------------------------------------------------------------------
6362:

Line 7416: ((NATURAL_ACCOUNT_ID =M_PARENT_ACCOUNT_ID) or (NATURAL_ACCOUNT_ID in (select CHILD_NATURAL_ACCOUNT_ID from amw_fin_key_acct_flat

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:
7419: -----------------------------------------------------------------------------------------
7420:

Line 7425: select PARENT_NATURAL_ACCOUNT_ID from amw_fin_key_acct_flat

7421: M_STATEMENT_GROUP_ID NUMBER :=0;
7422: M_STATEMENT_ID NUMBER :=0;
7423:
7424: cursor getParentAcc IS
7425: select PARENT_NATURAL_ACCOUNT_ID from amw_fin_key_acct_flat
7426: where CHILD_NATURAL_ACCOUNT_ID =P_ACCOUNT_ID and ACCOUNT_GROUP_ID=p_ACCOUNT_GROUP_ID;
7427:
7428: --------------------------------------------------------------------------------------------
7429: cursor existing_codes