APPS.FA_CALC_DEPRN_BASIS2_PKG dependencies on FA_RETIREMENTS_MRC_V

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 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 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;