APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on PA_EXPENDITURE_TYPES

Line 1181: pa_expenditure_types

1177: x_progress := '001';
1178:
1179: /* Bug: 1786105 For all the following three validation select, the table/views:
1180: mtl_projects_v
1181: pa_expenditure_types
1182: per_organization_units
1183: needs to be replaced with
1184: pa_projects_expend_v
1185: pa_expenditure_types_expend_v

Line 1185: pa_expenditure_types_expend_v

1181: pa_expenditure_types
1182: per_organization_units
1183: needs to be replaced with
1184: pa_projects_expend_v
1185: pa_expenditure_types_expend_v
1186: pa_organizations_expend_v
1187: or else the projects validation would fail.
1188: */
1189: /* Bug 2892199 Added expenditure item date validation */

Line 1206: FROM pa_expenditure_types_expend_v pet

1202: nvl(pat.start_date,x_expenditure_item_date)
1203: AND nvl(pat.completion_date,x_expenditure_item_date) ;
1204:
1205: SELECT 'Y' into x_valid2
1206: FROM pa_expenditure_types_expend_v pet
1207: WHERE pet.expenditure_type = x_expenditure_type
1208: AND pet.system_linkage_function = 'VI';
1209:
1210: SELECT 'Y' into x_valid3

Line 1313: FROM pa_expenditure_types pet

1309: SELECT 'Y' into x_valid2
1310: FROM sys.dual
1311: WHERE x_expenditure_type IS NULL
1312: OR EXISTS( SELECT 'Valid Expenditure Type'
1313: FROM pa_expenditure_types pet
1314: WHERE pet.expenditure_type =
1315: x_expenditure_type
1316: AND pet.system_linkage_function = 'VI'
1317: );