APPS.PAAPIMP_PKG dependencies on PA_PROJECTS_ALL

Line 184: pa_projects_all PROJ

180:
181: SELECT decode(PTYPE.Project_Type_Class_Code,'CAPITAL','P','X')
182: INTO G_Assets_Addition_flag
183: FROM pa_project_types_all PTYPE,
184: pa_projects_all PROJ
185: WHERE PTYPE.Project_Type = PROJ.Project_Type
186: AND (PTYPE.org_id = PROJ.org_id OR
187: PROJ.org_id is null)
188: AND PROJ.Project_Id = G_PROJECT_ID;

Line 1400: FROM pa_project_types_all ptype, pa_projects_all proj

1396: program_application_id = G_PROG_APPL_ID,
1397: program_update_date = SYSDATE, --bug 3905111
1398: dist.assets_addition_flag = (SELECT decode(ptype.project_type_class_code,
1399: 'CAPITAL','P', dist.assets_addition_flag)
1400: FROM pa_project_types_all ptype, pa_projects_all proj
1401: WHERE ptype.project_type = proj.project_type
1402: AND (ptype.org_id = proj.org_id
1403: OR proj.org_id is null)
1404: AND proj.project_id = dist.project_id)

Line 1519: FROM pa_project_types_all ptype, pa_projects_all proj

1515: program_application_id = G_PROG_APPL_ID,
1516: program_update_date = SYSDATE, --bug 3905111
1517: dist.assets_addition_flag = (SELECT decode(ptype.project_type_class_code,
1518: 'CAPITAL','P', dist.assets_addition_flag)
1519: FROM pa_project_types_all ptype, pa_projects_all proj
1520: WHERE ptype.project_type = proj.project_type
1521: AND (ptype.org_id = proj.org_id OR
1522: proj.org_id is null)
1523: AND proj.project_id = dist.project_id)

Line 4108: pa_projects_all PROJ

4104:
4105: SELECT decode(PTYPE.Project_Type_Class_Code,'CAPITAL','P','X')
4106: INTO l_assets_addflag_tbl(i)
4107: FROM pa_project_types_all PTYPE,
4108: pa_projects_all PROJ
4109: WHERE PTYPE.Project_Type = PROJ.Project_Type
4110: AND (PTYPE.org_id = PROJ.org_id OR
4111: PROJ.org_id is null)
4112: AND PROJ.Project_Id = l_project_id_tbl(i);

Line 8583: pa_projects_all PROJ

8579:
8580: SELECT decode(PTYPE.Project_Type_Class_Code,'CAPITAL','P','X')
8581: INTO l_assets_addflag_tbl(i)
8582: FROM pa_project_types_all PTYPE,
8583: pa_projects_all PROJ
8584: WHERE PTYPE.Project_Type = PROJ.Project_Type
8585: AND (PTYPE.org_id = PROJ.org_id OR
8586: PROJ.org_id is null)
8587: AND PROJ.Project_Id = l_project_id_tbl(i);

Line 10874: pa_projects_all PROJ

10870:
10871: SELECT decode(PTYPE.Project_Type_Class_Code,'CAPITAL','P','X')
10872: INTO l_assets_addflag_tbl(i)
10873: FROM pa_project_types_all PTYPE,
10874: pa_projects_all PROJ
10875: WHERE PTYPE.Project_Type = PROJ.Project_Type
10876: AND (PTYPE.org_id = PROJ.org_id OR
10877: PROJ.org_id is null)
10878: AND PROJ.Project_Id = l_project_id_tbl(i);