APPS.PA_FP_VIEW_PLANS_TXN_PUB dependencies on PA_RESOURCES

Line 174: (p_resource_id IN pa_resources.resource_id%TYPE) return VARCHAR2 is

170: return(l_task_number);
171: END;
172: /* ------------------------------------------------------------- */
173: function get_resource_name
174: (p_resource_id IN pa_resources.resource_id%TYPE) return VARCHAR2 is
175: l_resource_name pa_resources.name%TYPE;
176: BEGIN
177: select name
178: into l_resource_name

Line 175: l_resource_name pa_resources.name%TYPE;

171: END;
172: /* ------------------------------------------------------------- */
173: function get_resource_name
174: (p_resource_id IN pa_resources.resource_id%TYPE) return VARCHAR2 is
175: l_resource_name pa_resources.name%TYPE;
176: BEGIN
177: select name
178: into l_resource_name
179: from pa_resources

Line 179: from pa_resources

175: l_resource_name pa_resources.name%TYPE;
176: BEGIN
177: select name
178: into l_resource_name
179: from pa_resources
180: where resource_id = p_resource_id;
181: return l_resource_name;
182: EXCEPTION
183: WHEN NO_DATA_FOUND THEN

Line 1261: pa_resources pr -- added for bug 3463685

1257: 0 as margin_percent
1258: from pa_resource_assignments ra_cost,
1259: pa_budget_lines bl_cost,
1260: pa_resource_list_members rlm,
1261: pa_resources pr -- added for bug 3463685
1262: where ra_cost.budget_version_id = p_cost_version_id and
1263: ra_cost.resource_assignment_type = 'USER_ENTERED' and
1264: ra_cost.resource_assignment_id = bl_cost.resource_assignment_id and
1265: ra_cost.resource_list_member_id = rlm.resource_list_member_id and

Line 1337: pa_resources pr -- added for bug 3463685

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
1341: rlm.resource_id = pr.resource_id and -- added for bug 3463685

Line 1394: pa_resources pr -- Added for bug 3463685

1390: -- 0 as margin_percent
1391: from pa_resource_assignments ra_revenue,
1392: pa_budget_lines bl_revenue,
1393: pa_resource_list_members rlm,
1394: pa_resources pr -- Added for bug 3463685
1395: where ra_revenue.budget_version_id = p_revenue_version_id and
1396: ra_revenue.resource_assignment_type = 'USER_ENTERED' and
1397: ra_revenue.resource_assignment_id = bl_revenue.resource_assignment_id and
1398: ra_revenue.resource_list_member_id = rlm.resource_list_member_id and

Line 1455: pa_resources pr -- added for bug 3463685

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
1459: pr.resource_id = rlm.resource_id and -- bug 3463685

Line 1523: pa_resources pr -- Added for bug 3463685

1519: SUM(nvl(bl.txn_revenue,0)))) as margin_percent
1520: from pa_resource_assignments ra,
1521: pa_budget_lines bl,
1522: pa_resource_list_members rlm,
1523: pa_resources pr -- Added for bug 3463685
1524: where ra.budget_version_id = p_both_version_id and
1525: ra.resource_assignment_type = 'USER_ENTERED' and
1526: ra.resource_assignment_id = bl.resource_assignment_id and
1527: ra.resource_list_member_id = rlm.resource_list_member_id and

Line 1597: pa_resources pr -- Added for bug 3463685

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
1601: (p_filter_task_id = -1 or ra.task_id = p_filter_task_id) and

Line 1659: pa_resources pr -- added for bug 3463685

1655: 0 as margin,
1656: 0 as margin_percent
1657: from pa_resource_assignments ra,
1658: pa_resource_list_members rlm,
1659: pa_resources pr -- added for bug 3463685
1660: where ra.budget_version_id = p_cost_version_id and
1661: ra.resource_assignment_type = 'USER_ENTERED' and
1662: ra.resource_list_member_id = rlm.resource_list_member_id and
1663: pr.resource_id = rlm.resource_id and -- added for bug 3463685

Line 1714: pa_resources pr -- Added for bug 3463685

1710: -- 0 as margin,
1711: -- 0 as margin_percent
1712: from pa_resource_assignments ra,
1713: pa_resource_list_members rlm,
1714: pa_resources pr -- Added for bug 3463685
1715: where ra.budget_version_id = p_revenue_version_id and
1716: ra.resource_assignment_type = 'USER_ENTERED' and
1717: ra.resource_list_member_id = rlm.resource_list_member_id and
1718: pr.resource_id = rlm.resource_id and -- bug 3463685

Line 1797: pa_resources pr -- Added for bug 3463685

1793: (ra.total_plan_revenue - ra.total_plan_burdened_cost)/
1794: ra.total_plan_revenue))) as margin_percent
1795: from pa_resource_assignments ra,
1796: pa_resource_list_members rlm,
1797: pa_resources pr -- Added for bug 3463685
1798: where ra.budget_version_id = p_both_version_id and
1799: ra.resource_assignment_type = 'USER_ENTERED' and
1800: ra.resource_list_member_id = rlm.resource_list_member_id and
1801: pr.resource_id = rlm.resource_id and -- added for bug 3463685