DBA Data[Home] [Help]

APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on DUAL

Line 1349: FROM sys.dual

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.*/
1347:
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

Line 1364: FROM sys.dual

1360: When the Destination Type is INVENTORY then the expenditure Org can
1361: be NULL. */
1362:
1363: SELECT 'Y' into x_valid3
1364: FROM sys.dual
1365: WHERE x_expenditure_organization_id IS NULL
1366: OR EXISTS( SELECT 'Valid Expenditure Org'
1367: FROM per_organization_units pou
1368: WHERE pou.organization_id=