APPS.PAAPIMP_PKG dependencies on PA_PROJECT_TYPES_ALL

Line 183: FROM pa_project_types_all PTYPE,

179: End If;
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)

Line 1460: FROM pa_project_types_all ptype,

1456: program_application_id = G_PROG_APPL_ID,
1457: program_update_date = SYSDATE, --bug 3905111
1458: dist.assets_addition_flag = DECODE(NVL(
1459: (SELECT ptype.project_type_class_code
1460: FROM pa_project_types_all ptype,
1461: pa_projects_all proj
1462: WHERE ptype.project_type = proj.project_type
1463: AND (ptype.org_id = proj.org_id
1464: OR proj.org_id IS NULL)

Line 1515: FROM pa_project_types_all ptype, pa_projects_all proj

1511: program_application_id = G_PROG_APPL_ID,
1512: program_update_date = SYSDATE,
1513: dist.assets_addition_flag = (SELECT decode(ptype.project_type_class_code,
1514: 'CAPITAL','P', dist.assets_addition_flag)
1515: FROM pa_project_types_all ptype, pa_projects_all proj
1516: WHERE ptype.project_type = proj.project_type
1517: AND (ptype.org_id = proj.org_id
1518: OR proj.org_id is null)
1519: AND proj.project_id = dist.project_id)

Line 1680: FROM pa_project_types_all ptype,

1676: program_application_id = G_PROG_APPL_ID,
1677: program_update_date = SYSDATE, --bug 3905111
1678: dist.assets_addition_flag = DECODE(NVL(
1679: (SELECT ptype.project_type_class_code
1680: FROM pa_project_types_all ptype,
1681: pa_projects_all proj
1682: WHERE ptype.project_type = proj.project_type
1683: AND (ptype.org_id = proj.org_id
1684: OR proj.org_id IS NULL)

Line 1732: FROM pa_project_types_all ptype, pa_projects_all proj

1728: program_application_id = G_PROG_APPL_ID,
1729: program_update_date = SYSDATE,
1730: dist.assets_addition_flag = (SELECT decode(ptype.project_type_class_code,
1731: 'CAPITAL','P', dist.assets_addition_flag)
1732: FROM pa_project_types_all ptype, pa_projects_all proj
1733: WHERE ptype.project_type = proj.project_type
1734: AND (ptype.org_id = proj.org_id OR
1735: proj.org_id is null)
1736: AND proj.project_id = dist.project_id)

Line 5247: FROM pa_project_types_all PTYPE,

5243: write_log(LOG, G_err_stage);
5244:
5245: SELECT decode(PTYPE.Project_Type_Class_Code,'CAPITAL','P','X')
5246: INTO l_assets_addflag_tbl(i)
5247: FROM pa_project_types_all PTYPE,
5248: pa_projects_all PROJ
5249: WHERE PTYPE.Project_Type = PROJ.Project_Type
5250: AND (PTYPE.org_id = PROJ.org_id OR
5251: PROJ.org_id is null)

Line 10295: FROM pa_project_types_all PTYPE,

10291: write_log(LOG, G_err_stage);
10292:
10293: SELECT decode(PTYPE.Project_Type_Class_Code,'CAPITAL','P','X')
10294: INTO l_assets_addflag_tbl(i)
10295: FROM pa_project_types_all PTYPE,
10296: pa_projects_all PROJ
10297: WHERE PTYPE.Project_Type = PROJ.Project_Type
10298: AND (PTYPE.org_id = PROJ.org_id OR
10299: PROJ.org_id is null)

Line 12634: FROM pa_project_types_all PTYPE,

12630: write_log(LOG, G_err_stage);
12631:
12632: SELECT decode(PTYPE.Project_Type_Class_Code,'CAPITAL','P','X')
12633: INTO l_assets_addflag_tbl(i)
12634: FROM pa_project_types_all PTYPE,
12635: pa_projects_all PROJ
12636: WHERE PTYPE.Project_Type = PROJ.Project_Type
12637: AND (PTYPE.org_id = PROJ.org_id OR
12638: PROJ.org_id is null)