[Home] [Help]
97: So, pa_proj_fp_options_id is used to fetch options_id
98: */
99: cursor unentered_csr is
100: select txn_currency_code
101: from pa_fp_txn_currencies txncurr,
102: pa_proj_fp_options pfo
103: where pfo.fin_plan_version_id = l_budget_version_id and
104: txncurr.proj_fp_options_id = pfo.proj_fp_options_id and
105: not (txn_currency_code in
1332: (ra.total_plan_revenue - ra.total_plan_raw_cost)/
1333: ra.total_plan_revenue)) as margin_percent -- null
1334: from pa_resource_assignments ra,
1335: pa_resource_list_members rlm,
1336: pa_fp_txn_currencies ftc,
1337: pa_resources pr -- added for bug 3463685
1338: where ra.budget_version_id = p_cost_version_id and
1339: ra.resource_assignment_type = 'USER_ENTERED' and
1340: ra.resource_list_member_id = rlm.resource_list_member_id and
1450: -- 0 as margin,
1451: -- 0 as margin_percent
1452: from pa_resource_assignments ra,
1453: pa_resource_list_members rlm,
1454: pa_fp_txn_currencies ftc,
1455: pa_resources pr -- added for bug 3463685
1456: where ra.budget_version_id = p_revenue_version_id and
1457: ra.resource_assignment_type = 'USER_ENTERED' and
1458: ra.resource_list_member_id = rlm.resource_list_member_id and
1592: (ra.total_plan_revenue - ra.total_plan_raw_cost)/
1593: ra.total_plan_revenue)) as margin_percent -- null
1594: from pa_resource_assignments ra,
1595: pa_resource_list_members rlm,
1596: pa_fp_txn_currencies ftc,
1597: pa_resources pr -- Added for bug 3463685
1598: where ra.budget_version_id = p_both_version_id and
1599: ra.resource_assignment_type = 'USER_ENTERED' and
1600: ra.resource_list_member_id = rlm.resource_list_member_id and