APPS.PA_FIN_PLAN_UTILS2 dependencies on PA_RESOURCE_ASSIGNMENTS

Line 1719: ,pa_resource_assignments ra

1715: FROM DUAL
1716: WHERE EXISTS
1717: (SELECT null
1718: FROM pa_budget_lines bl
1719: ,pa_resource_assignments ra
1720: WHERE ra.budget_version_id = l_budget_version_id
1721: and ra.wbs_element_version_id = p_task_str_version_id
1722: and bl.resource_assignment_id = ra.resource_assignment_id
1723: and bl.cost_rejection_code is NOT NULL

Line 1736: ,pa_resource_assignments ra

1732: FROM DUAL
1733: WHERE EXISTS
1734: (SELECT null
1735: FROM pa_budget_lines bl
1736: ,pa_resource_assignments ra
1737: WHERE ra.budget_version_id = l_budget_version_id
1738: and ra.wbs_element_version_id = p_task_str_version_id
1739: and bl.resource_assignment_id = ra.resource_assignment_id
1740: and bl.burden_rejection_code is NOT NULL

Line 1753: ,pa_resource_assignments ra

1749: FROM DUAL
1750: WHERE EXISTS
1751: (SELECT null
1752: FROM pa_budget_lines bl
1753: ,pa_resource_assignments ra
1754: WHERE ra.budget_version_id = l_budget_version_id
1755: and ra.wbs_element_version_id = p_task_str_version_id
1756: and bl.resource_assignment_id = ra.resource_assignment_id
1757: and bl.revenue_rejection_code is NOT NULL

Line 1770: ,pa_resource_assignments ra

1766: FROM DUAL
1767: WHERE EXISTS
1768: (SELECT null
1769: FROM pa_budget_lines bl
1770: ,pa_resource_assignments ra
1771: WHERE ra.budget_version_id = l_budget_version_id
1772: and ra.wbs_element_version_id = p_task_str_version_id
1773: and bl.resource_assignment_id = ra.resource_assignment_id
1774: and bl.pc_cur_conv_rejection_code is NOT NULL

Line 1787: ,pa_resource_assignments ra

1783: FROM DUAL
1784: WHERE EXISTS
1785: (SELECT null
1786: FROM pa_budget_lines bl
1787: ,pa_resource_assignments ra
1788: WHERE ra.budget_version_id = l_budget_version_id
1789: and ra.wbs_element_version_id = p_task_str_version_id
1790: and bl.resource_assignment_id = ra.resource_assignment_id
1791: and bl.pfc_cur_conv_rejection_code is NOT NULL

Line 2547: FROM pa_resource_assignments ra

2543: ,NVL(ra.rate_based_flag,'N') rate_based_flag
2544: ,ra.rate_expenditure_org_id
2545: ,p_project_type
2546: ,p_plsql_index_tab(i)
2547: FROM pa_resource_assignments ra
2548: WHERE ra.resource_assignment_id = p_resource_assignment_id_tab(i);
2549:
2550: END IF;
2551: print_msg(p_pa_debug_mode,'populate_ra_details','End of populate_ra_details retSts['||x_return_status||']');