APPS.AP_MASS_ADDITIONS_CREATE_PKG dependencies on PA_PROJECTS_ALL

Line 440: pa_projects_all proj

436: AND apid.assets_tracking_flag = 'Y'
437: AND ( APID.project_id IS NULL
438: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
439: FROM pa_project_types_all ptype,
440: pa_projects_all proj
441: WHERE proj.project_type = ptype.project_type
442: AND ptype.org_id = proj.org_id
443: AND proj.project_id = APID.project_id
444: ) <> 'P'

Line 489: pa_projects_all proj

485: item.invoice_distribution_id -- Bug 12660674
486: AND ( APID.project_id IS NULL
487: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
488: FROM pa_project_types_all ptype,
489: pa_projects_all proj
490: WHERE proj.project_type = ptype.project_type
491: AND ptype.org_id = proj.org_id
492: AND proj.project_id = APID.project_id
493: ) <> 'P'

Line 534: pa_projects_all proj

530: AND NVL(APID.charge_applicable_to_dist_id,APID.corrected_invoice_dist_id) IS NULL --Bug#14495604 added in case of invoice corrections
531: AND ( APID.project_id IS NULL
532: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
533: FROM pa_project_types_all ptype,
534: pa_projects_all proj
535: WHERE proj.project_type = ptype.project_type
536: AND ptype.org_id = proj.org_id
537: AND proj.project_id = APID.project_id
538: ) <> 'P'

Line 576: pa_projects_all proj

572: AND satx.charge_applicable_to_dist_id = item.invoice_distribution_id
573: AND ( satx.project_id IS NULL
574: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
575: FROM pa_project_types_all ptype,
576: pa_projects_all proj
577: WHERE proj.project_type = ptype.project_type
578: AND ptype.org_id = proj.org_id
579: AND proj.project_id = satx.project_id
580: ) <> 'P' )

Line 939: pa_projects_all proj

935: AND apid.assets_tracking_flag = 'Y'
936: AND ( APID.project_id IS NULL
937: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
938: FROM pa_project_types_all ptype,
939: pa_projects_all proj
940: WHERE proj.project_type = ptype.project_type
941: AND ptype.org_id = proj.org_id
942: AND proj.project_id = APID.project_id
943: ) <> 'P'

Line 987: pa_projects_all proj

983: item.invoice_distribution_id -- Bug 12660674
984: AND ( APID.project_id IS NULL
985: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
986: FROM pa_project_types_all ptype,
987: pa_projects_all proj
988: WHERE proj.project_type = ptype.project_type
989: AND ptype.org_id = proj.org_id
990: AND proj.project_id = APID.project_id
991: ) <> 'P'

Line 1032: pa_projects_all proj

1028: AND NVL(APID.charge_applicable_to_dist_id,APID.corrected_invoice_dist_id) IS NULL --Bug#14495604 added in case of invoice corrections
1029: AND ( APID.project_id IS NULL
1030: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
1031: FROM pa_project_types_all ptype,
1032: pa_projects_all proj
1033: WHERE proj.project_type = ptype.project_type
1034: AND ptype.org_id = proj.org_id
1035: AND proj.project_id = APID.project_id
1036: ) <> 'P'

Line 1075: pa_projects_all proj

1071: AND satx.charge_applicable_to_dist_id = item.invoice_distribution_id
1072: AND ( satx.project_id IS NULL
1073: OR ( SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
1074: FROM pa_project_types_all ptype,
1075: pa_projects_all proj
1076: WHERE proj.project_type = ptype.project_type
1077: AND ptype.org_id = proj.org_id
1078: AND proj.project_id = satx.project_id
1079: ) <> 'P' )

Line 1887: pa_projects_all proj

1883: AND ( APID.project_id IS NULL
1884: OR
1885: (SELECT decode(ptype.project_type_class_code,'CAPITAL','P','U')
1886: FROM pa_project_types_all ptype,
1887: pa_projects_all proj
1888: WHERE proj.project_type = ptype.project_type
1889: AND ptype.org_id = proj.org_id
1890: AND proj.project_id = APID.project_id
1891: ) <> 'P' );