APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on PA_EXPENDITURE_TYPES

Line 1187: pa_expenditure_types

1183: x_progress := '001';
1184:
1185: /* Bug: 1786105 For all the following three validation select, the table/views:
1186: mtl_projects_v
1187: pa_expenditure_types
1188: per_organization_units
1189: needs to be replaced with
1190: pa_projects_expend_v
1191: pa_expenditure_types_expend_v

Line 1191: pa_expenditure_types_expend_v

1187: pa_expenditure_types
1188: per_organization_units
1189: needs to be replaced with
1190: pa_projects_expend_v
1191: pa_expenditure_types_expend_v
1192: pa_organizations_expend_v
1193: or else the projects validation would fail.
1194: */
1195: /* Bug 2892199 Added expenditure item date validation */

Line 1219: FROM pa_expenditure_types_expend_v pet

1215: end;
1216:
1217: begin
1218: SELECT 'Y' into x_valid2
1219: FROM pa_expenditure_types_expend_v pet
1220: WHERE pet.expenditure_type = x_expenditure_type
1221: AND pet.system_linkage_function = 'VI';
1222: exception
1223: when no_data_found then

Line 1342: respect to the pa_expenditure_types, However it should be validated

1338: --
1339: IF x_destination_type_code = 'INVENTORY' then
1340:
1341: /* bug 9412338/9831707 The expenditure_type was being validated with
1342: respect to the pa_expenditure_types, However it should be validated
1343: with respect to pa_expend_typ_sys_links.Because of this the project
1344: validations were failing.Added the table pa_expend_typ_sys_links to the
1345: from clause ,join condition in the where clause.System_linkage_function
1346: should be validated with the value in pa_expend_typ_sys_links table.*/

Line 1352: FROM pa_expenditure_types pet,

1348: SELECT 'Y' into x_valid2
1349: FROM sys.dual
1350: WHERE x_expenditure_type IS NULL
1351: OR EXISTS( SELECT 'Valid Expenditure Type'
1352: FROM pa_expenditure_types pet,
1353: pa_expend_typ_sys_links sl -- Bug 9412338/9831707
1354: WHERE pet.expenditure_type = x_expenditure_type
1355: AND pet.expenditure_type = sl.expenditure_type --bug9412338/9831707
1356: AND sl.system_linkage_function = 'VI' --bug9412338/9831707