APPS.PA_AGREEMENT_PVT dependencies on PA_PROJECT_TYPES_ALL

Line 1686: l_Allowable_Funding_Level_Code pa_project_types_all.ALLOWABLE_FUNDING_LEVEL_CODE%type; /*Added for bug 3614374*/

1682:
1683: l_Enable_Top_Task_Cust_Flag VARCHAR2(1);
1684: l_Exist_Flag VARCHAR2(1);
1685:
1686: l_Allowable_Funding_Level_Code pa_project_types_all.ALLOWABLE_FUNDING_LEVEL_CODE%type; /*Added for bug 3614374*/
1687:
1688: l_Inv_Method_Override_Flag VARCHAR2(1); /*Added for Bug 5550709*/
1689:
1690: BEGIN

Line 1839: From pa_project_types_all pt, pa_projects_all p

1835: * and add funding to the project.*/
1836:
1837: Select ALLOWABLE_FUNDING_LEVEL_CODE
1838: Into l_Allowable_Funding_Level_Code
1839: From pa_project_types_all pt, pa_projects_all p
1840: Where p.project_id=p_project_id
1841: And p.project_type=pt.project_type
1842: AND nvl(p.org_id,-99) = nvl(pt.org_id,-99);
1843: