DBA Data[Home] [Help]

APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_FISCAL_YEAR

Line 1781: FA_FISCAL_YEAR FY,

1777: select nvl(sum(RET.EOFY_RESERVE),0)
1778: from FA_RETIREMENTS RET,
1779: FA_TRANSACTION_HEADERS TH,
1780: FA_DEPRN_PERIODS DP,
1781: FA_FISCAL_YEAR FY,
1782: FA_BOOK_CONTROLS BC
1783: where RET.ASSET_ID= px_rule_in.asset_id
1784: and RET.BOOK_TYPE_CODE = px_rule_in.book_type_code
1785: and DP.BOOK_TYPE_CODE = px_rule_in.book_type_code

Line 1801: FA_FISCAL_YEAR FY,

1797: select nvl(sum(RET.EOFY_RESERVE),0)
1798: from FA_MC_RETIREMENTS RET,
1799: FA_TRANSACTION_HEADERS TH,
1800: FA_MC_DEPRN_PERIODS DP,
1801: FA_FISCAL_YEAR FY,
1802: FA_MC_BOOK_CONTROLS MBC,
1803: FA_BOOK_CONTROLS BC
1804: where RET.ASSET_ID= px_rule_in.asset_id
1805: and RET.BOOK_TYPE_CODE = px_rule_in.book_type_code

Line 1826: FA_FISCAL_YEAR FY,

1822: select nvl(sum(RET.EOFY_RESERVE),0)
1823: from FA_RETIREMENTS RET,
1824: FA_TRANSACTION_HEADERS TH,
1825: FA_DEPRN_PERIODS DP,
1826: FA_FISCAL_YEAR FY,
1827: FA_BOOK_CONTROLS BC
1828: where TH.ASSET_ID= px_rule_in.asset_id
1829: and TH.BOOK_TYPE_CODE = px_rule_in.book_type_code
1830: and DP.BOOK_TYPE_CODE = px_rule_in.book_type_code

Line 1852: FA_FISCAL_YEAR FY,

1848: select nvl(sum(RET.EOFY_RESERVE),0)
1849: from FA_MC_RETIREMENTS RET,
1850: FA_TRANSACTION_HEADERS TH,
1851: FA_MC_DEPRN_PERIODS DP,
1852: FA_FISCAL_YEAR FY,
1853: FA_MC_BOOK_CONTROLS MBC,
1854: FA_BOOK_CONTROLS BC
1855: where TH.ASSET_ID= px_rule_in.asset_id
1856: and TH.BOOK_TYPE_CODE = px_rule_in.book_type_code