APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_RETIREMENTS

Line 1606: from FA_RETIREMENTS RET,

1602:
1603: -- Get Eofy reserve retired on current fiscal year
1604: Cursor C_EOFY_RESERVE_RETIRED is
1605: select nvl(sum(RET.EOFY_RESERVE),0)
1606: from FA_RETIREMENTS RET,
1607: FA_TRANSACTION_HEADERS TH,
1608: FA_DEPRN_PERIODS DP,
1609: FA_FISCAL_YEAR FY,
1610: FA_BOOK_CONTROLS BC

Line 1626: from FA_RETIREMENTS_MRC_V RET,

1622: ;
1623:
1624: Cursor C_EOFY_RESERVE_RETIRED_M is
1625: select nvl(sum(RET.EOFY_RESERVE),0)
1626: from FA_RETIREMENTS_MRC_V RET,
1627: FA_TRANSACTION_HEADERS TH,
1628: FA_DEPRN_PERIODS_MRC_V DP,
1629: FA_FISCAL_YEAR FY,
1630: FA_BOOK_CONTROLS_MRC_V BC

Line 1646: from FA_RETIREMENTS RET,

1642: ;
1643:
1644: Cursor GP_EOFY_RESERVE_RETIRED is
1645: select nvl(sum(RET.EOFY_RESERVE),0)
1646: from FA_RETIREMENTS RET,
1647: FA_TRANSACTION_HEADERS TH,
1648: FA_DEPRN_PERIODS DP,
1649: FA_FISCAL_YEAR FY,
1650: FA_BOOK_CONTROLS BC

Line 1672: from FA_RETIREMENTS_MRC_V RET,

1668: ;
1669:
1670: Cursor GP_EOFY_RESERVE_RETIRED_M is
1671: select nvl(sum(RET.EOFY_RESERVE),0)
1672: from FA_RETIREMENTS_MRC_V RET,
1673: FA_TRANSACTION_HEADERS TH,
1674: FA_DEPRN_PERIODS_MRC_V DP,
1675: FA_FISCAL_YEAR FY,
1676: FA_BOOK_CONTROLS_MRC_V BC

Line 1699: from FA_RETIREMENTS RET

1695:
1696: -- current transaction's member eofy reserve retired
1697: Cursor CUR_EOFY_RESERVE_RETIRED is
1698: select nvl(sum(RET.EOFY_RESERVE),0)
1699: from FA_RETIREMENTS RET
1700: where RET.TRANSACTION_HEADER_ID_IN = px_rule_in.adj_mem_transaction_header_id
1701: ;
1702:
1703: Cursor CUR_EOFY_RESERVE_RETIRED_M is

Line 1705: from FA_RETIREMENTS_MRC_V RET

1701: ;
1702:
1703: Cursor CUR_EOFY_RESERVE_RETIRED_M is
1704: select nvl(sum(RET.EOFY_RESERVE),0)
1705: from FA_RETIREMENTS_MRC_V RET
1706: where RET.TRANSACTION_HEADER_ID_IN = px_rule_in.adj_mem_transaction_header_id
1707: ;
1708:
1709: l_retired_eofy_reserve NUMBER := 0;