APPS.AMW_FINSTMT_CERT_BES_PKG dependencies on AMW_FIN_KEY_ACCOUNTS_B

Line 3622: from amw_fin_key_accounts_b acc

3618: where acc.parent_natural_account_id = fika.natural_account_id
3619: and acc.account_group_id = fika.account_group_id
3620: union all
3621: select acc.natural_account_id
3622: from amw_fin_key_accounts_b acc
3623: where acc.natural_account_id = fika.natural_account_id
3624: and acc.account_group_id = fika.account_group_id
3625: ); */
3626:

Line 3661: FROM AMW_FIN_KEY_ACCOUNTS_B ACC

3657: AND ACC.PARENT_NATURAL_ACCOUNT_ID = FIKA.NATURAL_ACCOUNT_ID
3658: AND ACC.ACCOUNT_GROUP_ID = FIKA.ACCOUNT_GROUP_ID
3659: UNION ALL
3660: SELECT ACC.NATURAL_ACCOUNT_ID
3661: FROM AMW_FIN_KEY_ACCOUNTS_B ACC
3662: WHERE
3663: ACC.NATURAL_ACCOUNT_ID = AA.NATURAL_ACCOUNT_ID
3664: AND ACC.NATURAL_ACCOUNT_ID = FIKA.NATURAL_ACCOUNT_ID
3665: AND ACC.ACCOUNT_GROUP_ID = FIKA.ACCOUNT_GROUP_ID

Line 3693: FROM AMW_FIN_KEY_ACCOUNTS_B ACC,

3689: AND FIKA.NATURAL_ACCOUNT_ID = ACC.PARENT_NATURAL_ACCOUNT_ID
3690: AND FIKA.ACCOUNT_GROUP_ID = ACC.ACCOUNT_GROUP_ID
3691: UNION ALL
3692: SELECT ACC.NATURAL_ACCOUNT_ID
3693: FROM AMW_FIN_KEY_ACCOUNTS_B ACC,
3694: AMW_CERTIFICATION_B CERT,
3695: AMW_FIN_ITEMS_KEY_ACC FIKA
3696: WHERE CERT.CERTIFICATION_ID = p_certification_id
3697: AND FIKA.STATEMENT_GROUP_ID = CERT.STATEMENT_GROUP_ID