APPS.AHL_OSP_PO_PVT dependencies on PO_SYSTEM_PARAMETERS_ALL

Line 3364: FROM PO_SYSTEM_PARAMETERS_ALL

3360:
3361: -- cursor to check if PO numbering is set to 'MANUAL'
3362: CURSOR chk_manual_PO_Numbering (c_org_id NUMBER) IS
3363: SELECT 'X'
3364: FROM PO_SYSTEM_PARAMETERS_ALL
3365: WHERE user_defined_po_num_code = 'MANUAL'
3366: AND org_id = c_org_id;
3367:
3368: -- cursor to check if 'MANUAL' PO numbering type is set to 'ALPHANUMERIC'

Line 3371: FROM PO_SYSTEM_PARAMETERS_ALL

3367:
3368: -- cursor to check if 'MANUAL' PO numbering type is set to 'ALPHANUMERIC'
3369: CURSOR chk_manual_PO_Num_Type (c_org_id NUMBER) IS
3370: SELECT 'X'
3371: FROM PO_SYSTEM_PARAMETERS_ALL
3372: WHERE manual_po_num_type = 'ALPHANUMERIC'
3373: AND org_id = c_org_id;
3374:
3375: -- cursor to get the OSP order number for a given order id