eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_ACT_BUDGETS

Line 1722: FROM ozf_act_budgets

1718: request_currency,
1719: ARC_ACT_BUDGET_USED_BY,
1720: ACT_BUDGET_USED_BY_ID,
1721: APPROVED_IN_CURRENCY
1722: FROM ozf_act_budgets
1723: WHERE transfer_type = 'REQUEST'
1724: AND act_budget_used_by_id = cv_offer_id
1725: AND budget_source_id = cv_fund_id;
1726:

Line 6804: FROM ozf_act_budgets

6800: -- Modified for Multi-curr ER: need to use only accruals in claim currency
6801: CURSOR csr_source_fund(cv_offer_id IN NUMBER) IS
6802: SELECT budget_source_id,
6803: APPROVED_ORIGINAL_AMOUNT
6804: FROM ozf_act_budgets
6805: WHERE transfer_type = 'REQUEST'
6806: AND act_budget_used_by_id = cv_offer_id
6807: AND APPROVED_IN_CURRENCY = G_ACCRUAL_CURRENCY;
6808:

Line 6816: FROM ozf_act_budgets

6812: -- Modified for Multi-curr ER: need to use only accruals in claim currency
6813: -- The amount derived is in the fund currency and not in the functional currency
6814: CURSOR csr_source_fund_tot(cv_offer_id IN NUMBER) IS
6815: SELECT SUM(APPROVED_ORIGINAL_AMOUNT)
6816: FROM ozf_act_budgets
6817: WHERE transfer_type = 'REQUEST'
6818: AND act_budget_used_by_id = cv_offer_id
6819: AND APPROVED_IN_CURRENCY = G_ACCRUAL_CURRENCY;
6820:

Line 9724: , ozf_act_budgets fund

9720: , amount --7169388
9721: , fund.approved_in_currency --7231613
9722: FROM ozf_claim_lines_all lines
9723: , ozf_offers offr
9724: , ozf_act_budgets fund
9725: , ozf_sd_request_headers_all_b req
9726: WHERE claim_id = cv_claim_id
9727: AND lines.activity_id = req.request_header_id
9728: AND req.offer_id = offr.qp_list_header_id